RC_DIRDEP

(SQL Table)
Index Back

Payroll Param for PY_DIRDEP

Process Scheduler report parameter record utilized by direct deposit AE program PY_DIRDEP.

# 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 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

Prompt Table: PAY_RUN_TBL

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

5 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

6 PAY_END_DT Date(10) DATE Pay Period End Date

Prompt Table: PAY_CALENDAR

7 CYCLE_SELECT Character(1) VARCHAR2(1) NOT NULL Off-Cycle
B=Both
F=Off-Cycle
O=On-Cycle

Default Value: B

8 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

Default Value: N

9 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr

Prompt Table: PAY_PAGE

10 PAGE_NUM_THRU Number(5,0) INTEGER NOT NULL Thru Page Number

Prompt Table: PAY_PAGE

11 PRENOTE_DT Date(10) DATE Prenote Date
12 TEXT20 Character(20) VARCHAR2(20) NOT NULL Text (20 Characters)
13 PY_DDP_SEP_FILES Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether a user would like to create separate files for IAT vs DDP transactions when running the DDP001.sqr to create the US Direct deposit file.

Y/N Table Edit

Default Value: N

14 PY_DDP_EXCL_OFFS Character(1) VARCHAR2(1) NOT NULL This field is used to indicate whether a user would like to exclude the offset records from the US Direct deposit file when running DDP001.sqr

Y/N Table Edit

Default Value: N

15 PY_RESET_DDP Character(1) VARCHAR2(1) NOT NULL Reset direct deposit file indicator.

Y/N Table Edit

Default Value: N

16 PY_FILE_TAG Character(21) VARCHAR2(21) NOT NULL File Tag associated with the direct deposit file.