Payroll Personnel Data Warehouse

Payroll Personnel Data Warehouse


Table and Fields Description


Table Description --- COAOBJ






Fields Definition


Field Name Business Name Data Type Description
FIN_COA_CD CHART OF ACCOUNTS NUMBER VARCHAR2(1) Identifier of a Chart of Accounts.
FIN_CONS_OBJ_CD OBJECT CONSOLIDATION NUMBER VARCHAR2(4) Identifies a group of object levels and their associated object codes for budgeting and Office of the President requirements.
FIN_OBJ_CD_NM OBJECT NAME VARCHAR2(40) The descriptive name of the object.
FIN_OBJ_LEVEL_CD OBJECT LEVEL NUMBER VARCHAR2(4) Indicates an object code or an object code grouping for system monitoring and special routing and approval.
FIN_OBJ_SUB_TYP_CD OBJECT SUB TYPE CODE VARCHAR2(2) Code used to group object codes for special reporting.
FIN_OBJ_TYP_CD OBJECT TYPE CODE VARCHAR2(2) Identifies an object code as an asset, liability, expenditure, fund balance, etc.
FIN_OBJECT_CD OBJECT NUMBER VARCHAR2(4) Identifier used to classify accounting transactions by type. Examples are academic salries, in-state travel, Reg Fee income.
RPTS_TO_FIN_COA_CD OP REPORTS TO CHART OF ACCOUNTS NUMBER VARCHAR2(2) The Office of the President Chart to which this object reports.
RPTS_TO_FIN_OBJ_CD OP REPORTS TO OBJECT NUMBER VARCHAR2(4) The Office of the President Object to which this object reports.


Top of this page Table Description Data Dictionary PPS Main Menu


Sent Comment to: PPS Data Warehouse Support
Last Updated: July 16, 1997