GPNZ_RCN_AET

(SQL Table)
 Index Back

PDR Recon Run Control

Run Control Recor for New Zealand PDR process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 GPNZ_PDR_YEAR Character(4) VARCHAR2(4) NOT NULL Year code
5 GPNZ_RCN_RUN_TYPE Character(2) VARCHAR2(2) NOT NULL Reconciliaiton Run by parameters
10=Calendar Group
20=Payment Date
6 GPNZ_RCN_RPT_TYPE Character(2) VARCHAR2(2) NOT NULL report run by parameters for reconciliaiton
10=Employee Detail
20=Organizational Summary
7 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GPNZ_RCN_CAL_VW

8 PYMT_DT Date(10) DATE Payment Date

Prompt Table: GPNZ_RCN_PD_VW

9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY

10 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country
11 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set

Prompt Table: GP_RGST_SET_VW

12 GPNZ_PDR_SQL_TEXT Long Character CLOB To store SQL Text in AET during Application Engine Processing.
13 GPNZ_PDR_SQL_TEXT1 Long Character CLOB To store SQL Text in AET during Application Engine Processing.
14 GPNZ_PDR_SQL_TEXT2 Long Character CLOB To store SQL Text in AET during Application Engine Processing.
15 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
16 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
18 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
19 GPNZ_PDR_VERSION Number(10,0) DECIMAL(10) NOT NULL New Field - Version added for PDR
20 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
21 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
22 GPNZ_RCN_VR Character(2) VARCHAR2(2) NOT NULL Field created for GPNZL - Recon report