GPFR_DA_PAYGRP

(SQL Table)
Index Back

Pay Grp in Extract Process

DADS related record: store the pay groups to be included in the extraction process.

# 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 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_SNDREF

4 GPFR_DA_RECIP Character(10) VARCHAR2(10) NOT NULL DADS related field

Default Value: COMPLETE

Prompt Table: GPFR_DA_RECIP

5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP