GPNZ_PDR_RC_EEF

(SQL Table)
Index Back

PDR RunCntl Record EE File

New Zelanad, Payday Reporting - New and Departing Employee File Run control record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: PRCSRUNCNTL.RUN_CNTL_ID

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GPNZ_PDR_OPR_VW

4 GPNZ_PDR_FL_TYP Character(4) VARCHAR2(4) NOT NULL PDR Employment File Run Control - File Type
CSV=CSV
XLS=XLS
XML=XML

Default Value: CSV

5 FROM_DT Date(10) DATE NOT NULL From Date
6 TO_DT Date(10) DATE NOT NULL To Date
7 GPNZ_PDR_EEFT_CR Character(1) VARCHAR2(1) NOT NULL PDR - RunControl Place Holder for Create File for xml

Y/N Table Edit

Default Value: N

8 GPNZ_PDR_EEFT_UP Character(1) VARCHAR2(1) NOT NULL PDR - RunControl Place Holder for Update File

Y/N Table Edit

Default Value: N

9 GPNZ_PDR_EEFT_TE Character(1) VARCHAR2(1) NOT NULL PDR - RunControl Place Holder for Update File for xml

Y/N Table Edit

Default Value: N

10 GPNZ_PDR_EEFT_AL Character(1) VARCHAR2(1) NOT NULL PDR Employee File - File Type for xml

Y/N Table Edit

Default Value: N