GPAU_STP_REC_RC

(SQL Table)
Index Back

Run Ctrl STP REconciliation

Run Control for STP Reconciliation

# 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 GPAU_STP_RPT Character(30) VARCHAR2(30) NOT NULL STP Report Values
1=PAYEVNT
2=PAYEVNTEMP
3=ALL

Default Value: ALL

Prompt Table: GPAU_STP_RCAT
Set Control Field: GPAU_STP_RPT

4 GPAU_TAX_YEAR Number(4,0) SMALLINT NOT NULL Tax Year - End of Year Processing
5 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT_SGPAU

6 GPAU_STP_PREP_IND Character(1) VARCHAR2(1) NOT NULL Header - STP Preparation Process
7 GPAU_PROCESS_BY Character(1) VARCHAR2(1) NOT NULL Processing Option of STP Preparation Process.. Options are: By Pay Entity, Pay Group, Employee, Stream, Group List.
E=Emplid
G=Group List
N=Pay Entity
P=Pay Group
R=Period End Date
S=Streams

Default Value: N

8 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GPAU_CALRUN_VW

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: %RECNAME_EDIT

10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: GPAU_EMPRCD_VW

11 BALANCE_GRP_NUM Character(3) VARCHAR2(3) NOT NULL This field will be used to determine the grouping of balances from the different jobs of the employee.

Prompt Table: GPAU_EEBLGRP_VW

12 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List

Prompt Table: GP_GRP_LIST_VW

13 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

Prompt Table: GPAU_STRM_VW

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

Prompt Table: GPAU_PYGRP_VW

15 GPAU_TAX_YR_BGN_DT Date(10) DATE Begin Date
16 GPAU_TAX_YR_END_DT Date(10) DATE End Date
17 GPAU_STP_FINAL_IND Character(1) VARCHAR2(1) NOT NULL Finalized Payroll Indicator - Single Touch Payroll

Y/N Table Edit

18 PRD_END_DT Date(10) DATE Pay Period End Date

Prompt Table: GPAU_PRDEND_DVW

19 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

Prompt Table: GPAU_CALPRD_DVW

20 GPAU_STP_PRC_CLGRP Character(1) VARCHAR2(1) NOT NULL Processed Calender Groups - Single Touch Payroll
21 SELECT_ALL Character(1) VARCHAR2(1) NOT NULL Select All
22 DESELECT_ALL Character(1) VARCHAR2(1) NOT NULL Deselect All
23 GPAU_STP_EEDIFF Character(1) VARCHAR2(1) NOT NULL GPAU_STP_REC
N=No
Y=Yes

Default Value: Y

24 GPAU_STP_OVRD Character(1) VARCHAR2(1) NOT NULL GPAU_STP_OVRD
N=No
Y=Yes

Default Value: N