RIAS_FULLMAPPING_PROJECTSFLAG¶
- 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=""