GPES_RC_FDI

(SQL Table)
Index Back

Run Control for FDI Report ESP

Run Control for FDI Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 GPES_SENDING_ID Character(10) VARCHAR2(10) NOT NULL Sending ID
4 GPES_CONFIRM_SEND Character(1) VARCHAR2(1) NOT NULL Confirmed Send
1=Included in FDI
N=No Communicated
Y=FDI Sent Confirmed
5 GPES_FILENAME Character(8) VARCHAR2(8) NOT NULL FDI File Name or EFT File Name
6 FILE_PATH Character(127) VARCHAR2(127) NOT NULL Input/Output file path
7 DATE_FROM Date(10) DATE NOT NULL Date From
8 DATE_TO Date(10) DATE NOT NULL Previous Period Date To
9 GPES_ADD_SECURITY Character(1) VARCHAR2(1) NOT NULL Add Security Period

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

13 GPES_FDI_MT_FLAG Character(1) VARCHAR2(1) NOT NULL Maternity/Paternity Note

Y/N Table Edit

Default Value: N

14 GPES_FDI_RE_FLAG Character(1) VARCHAR2(1) NOT NULL Risk during pregnancy or lactancy

Y/N Table Edit

Default Value: N

15 GPES_FDI_CC_FLAG Character(1) VARCHAR2(1) NOT NULL Child Care

Y/N Table Edit

Default Value: N

16 GPES_FDI_ED_FLAG Character(1) VARCHAR2(1) NOT NULL Medical Discharge

Y/N Table Edit

Default Value: N

17 SOCS_AUTH_KEY_ESP Character(8) VARCHAR2(8) NOT NULL Authorization Key

Prompt Table: SOCS_SETHD_VW