GPAU_TFN_EL_AET

(SQL Table)
Index Back

State Record for PS Creation

State record for Payment Summary Creation Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 GPAU_TFN_START_DT Date(10) DATE TFN Report Start Date
5 GPAU_TFN_END_DT Date(10) DATE TFN Report End Date
6 GPAU_RUN_TYPE Character(2) VARCHAR2(2) NOT NULL Run Type for EOY Magnetic Type
10=Production
20=Test
7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
8 GPAU_PSM_FILE_NM Character(30) VARCHAR2(30) NOT NULL File name for EOY Processing
9 GPAU_PSM_REC_CNT Number(8,0) INTEGER NOT NULL Rcord Count for PSM Elcetronic file
10 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp