.. index:: RIAS_FULLMAPPING_PROJECTSFLAG ============================= RIAS_FULLMAPPING_PROJECTSFLAG ============================= .. default-role:: doc :Description: Table used in Solutions AccountMapper program to fill the data in top search box. Downloaded from a Rutgers source (ask Cornelia Kinsella for source) Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **CODE_COMBINATION_ID** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Fund_Source_Index** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Legacy_Org** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Legacy_Natural_Account** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **BRC** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Balance_Sheet_Code** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **FUNCTION_CODE** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **FUND_SOURCE_CLASSIFICATION_CDE** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **CAMPUS_CODE** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Unit_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_UNIT_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Division_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_DIVISION_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Organization_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_ORGANIZATION_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Location_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_LOCATION_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Fund_Type_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_FUND_TYPE_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Business_Line_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_BUSINESS_LINE_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **New_Natural_Account_Cd** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **NEW_NATURAL_ACCOUNT_DESCR** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Source** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Mapping_Change** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **FullyMapped** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **FullComboCode** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Project_Type** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Project_Number** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **Project_Name** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **last_change** ``timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()`` :Options: ``display="true", null="true", search="false", type=""``