GP_RGST_EXT_AET

(SQL Table)
 Index Back

Payroll Register State Table

Payroll Results Register State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_CAL_GRP_SRCH

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
4 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country
5 DATE_FROM Date(10) DATE Date From
6 DATE_TO Date(10) DATE Previous Period Date To
7 GB_EFFDT Date(10) DATE Group As Of Date
8 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
9 GB_REFINE_DATE Date(10) DATE Refinement Date
10 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set
11 GP_GENRPT_BLD_GRP Character(1) VARCHAR2(1) NOT NULL Indicates if the group build must be rebuilt or not
12 GP_RGST_POPUL_TYPE Character(2) VARCHAR2(2) NOT NULL This field controls the method of selecting the employee population for the Payroll Results Register report.
10=All Payees
20=HR Group Build
30=GP Group List
40=Payees
13 GP_RGST_PRD_TYPE Character(2) VARCHAR2(2) NOT NULL This field identifies the type of period that will be utilized on the run control.
10=Period Begin Date Range
20=Period End Date Range
30=Payment Date Range
40=Year and Quarter
14 GP_RGST_QTR Character(2) VARCHAR2(2) NOT NULL This field defines the quarter parameter for the Results Register.
01=1st Quarter
02=2nd Quarter
03=3rd Quarter
04=4th Quarter
15 GP_RGST_RUN_TYPE Character(2) VARCHAR2(2) NOT NULL The Field is used to define how the Payroll Results Regsiter will be run.
10=Calendar Group
20=Period
16 GP_RGST_YEAR Number(4,0) SMALLINT NOT NULL This field defines the year parameter for the Results Register.
17 GP_RPT_ID Character(18) VARCHAR2(18) NOT NULL Extraction Process Name
18 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List
19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
20 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID