| # |
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 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GP_CAL_RUNP_VW
|
| 4 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
GP_COUNTRY
|
| 5 |
COUNTRY2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 6 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 7 |
DATE_TO |
Date(10) |
DATE |
Previous Period Date To
|
| 8 |
GP_ELN_SET |
Character(15) |
VARCHAR2(15) NOT NULL |
Element Set
Prompt Table:
GP_RGST_SET_VW
|
| 9 |
GB_EFFDT |
Date(10) |
DATE |
Group As Of Date
|
| 10 |
GB_REFINE_DATE |
Date(10) |
DATE |
Refinement Date
|
| 11 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_SEC_VW
|
| 12 |
GP_GENRPT_BLD_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if the group build must be rebuilt or not
Y/N Table Edit
Default Value: N
|
| 13 |
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
Default Value: 10
|
| 14 |
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
|
| 15 |
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
|
| 16 |
GP_RGST_RPT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
This field controls the type of report that will be printed for the Payroll Results Register.
10=Employee Detail
20=Employee Summary
30=Organizational Summary
Default Value: 10
|
| 17 |
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
Default Value: 10
|
| 18 |
GP_RGST_SRT_CALG |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for the calendar group.
|
| 19 |
GP_RGST_SRT_COMP |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for company.
|
| 20 |
GP_RGST_SRT_DEPTID |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for department.
|
| 21 |
GP_RGST_SRT_EMPL |
Character(2) |
VARCHAR2(2) NOT NULL |
This field is the sort sequence for employee
10=Employee Name and Empl Rcd Nbr
20=Employee ID and Empl Rcd Nbr
Default Value: 10
|
| 22 |
GP_RGST_SRT_ESTAB |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for establishment
|
| 23 |
GP_RGST_SRT_LOCN |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for location
|
| 24 |
GP_RGST_SRT_PAYG |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for pay group
|
| 25 |
GP_RGST_SRT_PYENT |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for pay entity
|
| 26 |
GP_RGST_SRT_RUNTYP |
Number(3,0) |
SMALLINT NOT NULL |
This field determines whether Run Type will be used as a sort on the payroll register.
|
| 27 |
GP_RGST_SRT_CURR |
Number(3,0) |
SMALLINT NOT NULL |
This field is the sort sequence for the currency
|
| 28 |
GP_RGST_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
This field defines the year parameter for the Results Register.
|
| 29 |
GROUP_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Group List ID
Prompt Table:
GP_GRP_LIST_VW
|
| 30 |
VERSIONGBQDM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version Number
Prompt Table:
GP_GRPBLD_VW
|