GPCHEG1_AET

(SQL Table)
Index Back

ELM EG1 State Record

ELM EG1 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 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 GPCH_RUN_OPTIONS Character(1) VARCHAR2(1) NOT NULL Run Options for Individual Reports in Year end Processing
N=NO
Y=YES
5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
6 GPCH_RC_DT_OPT Character(1) VARCHAR2(1) NOT NULL Date Option
D=Date Range
Y=Yearly Report

Default Value: Y

7 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
8 GPCH_RC_FROM_DT Date(10) DATE From Date
9 GPCH_RC_TO_DT Date(10) DATE To Date

Prompt Table: GPCH_RP_DATE_VW

10 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

11 SETID Character(5) VARCHAR2(5) NOT NULL SetID
12 GPCH_RC_ADJUST_DT Date(10) DATE Use for the report GPCHSI08
13 GPCH_RC_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Run Type
A=Interface
B=Print
C=Interface and Print
D=Finalise
E=Print Earlier Version

Default Value: C

14 GPCH_RC_INC_P_CALC Character(1) VARCHAR2(1) NOT NULL Include Pending Calculations

Y/N Table Edit

Default Value: N

15 GPCH_RC_APLY_SPLIT Character(1) VARCHAR2(1) NOT NULL Apply Split

Y/N Table Edit

Default Value: N

16 GPCH_EG_YEP_FLG Character(1) VARCHAR2(1) NOT NULL Flag to check whether the Reports are Run from Year End Dashboard
17 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets