GPES_FDI_AET

(SQL Table)
Index Back

FDI Generation AET

FDI generation AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 GPES_FILENAME Character(8) VARCHAR2(8) NOT NULL FDI File Name or EFT File Name
5 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
6 DATE_FROM Date(10) DATE Date From
7 DATE_TO Date(10) DATE Previous Period Date To
8 GPES_ADD_SECURITY Character(1) VARCHAR2(1) NOT NULL Add Security Period

Y/N Table Edit

Default Value: N

9 GPES_FDI_PA_FLAG Character(1) VARCHAR2(1) NOT NULL Medical Discharge

Y/N Table Edit

Default Value: N

10 GPES_FDI_PB_FLAG Character(1) VARCHAR2(1) NOT NULL Sick Note

Y/N Table Edit

Default Value: N

11 GPES_FDI_PC_FLAG Character(1) VARCHAR2(1) NOT NULL Confirmation Note

Y/N Table Edit

Default Value: N

12 GPES_SENDING_ID Character(10) VARCHAR2(10) NOT NULL Sending ID
13 SOCS_AUTH_KEY_ESP Character(8) VARCHAR2(8) NOT NULL Authorization Key