EX_AE_MAIN_AET

(SQL Table)
Index Back

Expenses AE Main State Record

Expenses AE Main State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
3 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
4 RPT_DT Date(10) DATE Report Date
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr