GPGB_PENE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	GPGB_PRCRN_DATE	Date(10)	DATE	GBR AutoEnrollment Process run date
5	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
8	GPGB_QPEN_SCHEME	Character(10)	VARCHAR2(10) NOT NULL	Pension Scheme for GBR
9	GPGB_PEN_SCHEME	Character(4)	VARCHAR2(4) NOT NULL	Pension Scheme Code AVC1=AVC1 FIXA=Fixed Scheme A PCTB=Percentage Scheme B
10	GPGB_PEN_EVENT	Character(20)	VARCHAR2(20) NOT NULL	Pension Events GBR
11	GPGB_PEN_A_STATUS	Character(50)	VARCHAR2(50) NOT NULL	Pension Applicant Status GBR
12	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
13	END_DATE	Date(10)	DATE	End Date
14	GPGB_EE_PCTG_CONT	Number(6,2)	DECIMAL(5,2) NOT NULL	Employee's Percentage Contribution
15	GPGB_ER_PCTG_CONT	Number(6,2)	DECIMAL(5,2) NOT NULL	Employer's Percentage Contribution
16	GPGB_EE_PEN_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Employers Flat Amount Contribution
17	GPGB_ER_PEN_AMT	Number(10,2)	DECIMAL(9,2) NOT NULL	Employers Pension Fixed Amount
18	GPGB_QEARNING	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Qualifying Earning GBR
19	BIRTHDATE	Date(10)	DATE	Date of Birth
20	GPGB_STATE_PEN_AGE	Number(6,2)	DECIMAL(5,2) NOT NULL	State Pension Age GBR
21	GPGB_OPTIN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pension Opt In Flag for GBR 0=NO 1=YES
22	GPGB_OPTIN_RE	Character(1)	VARCHAR2(1) NOT NULL	Pension Opt In Flag for Re-Enrolment GBR 0=NO 1=YES
23	GPGB_OPTOUT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pension Opt Out Flag for GBR 0=None 1=Opt-Out 2=Cease
24	GPGB_OPTOUT_ST_DT	Date(10)	DATE	GBR pension optout start date field
25	GPGB_OPTOUT_END_DT	Date(10)	DATE	GBR pension optout date field
26	GPGB_POSTPONE_DT	Date(10)	DATE	GBR postpone till date field
27	GPGB_POSTPONE_RSN	Character(4)	VARCHAR2(4) NOT NULL	Pension Postponement reason for GBR JDDF=Job Holder Deferment SDDF=Staging Date Deferment WRDF=Worker Deferement
28	GPGB_AGGER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Aggregate Earning Flag for GBR 0=NO 1=YES
29	GPGB_NOTPRC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Do not Process Flag for GBR 0=NO 1=YES
30	GPGB_OVRPEN_SCHEME	Character(10)	VARCHAR2(10) NOT NULL	Pension Scheme for GBR
31	GPGB_PEN_REFUND	Character(1)	VARCHAR2(1) NOT NULL	Refund Flag for GBR 0=NO 1=YES
32	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
33	FREQ_ANNUAL_FACTOR	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
34	PRD_BGN_DT	Date(10)	DATE	Period Begin Date
35	PRD_END_DT	Date(10)	DATE	Pay Period End Date
36	GPGB_PEN_THRESHOLD	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Automatic Enrollment Threshold GBR
37	GPGB_PEN_QELL	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Qualifying Earning Lower Limit GBR
38	GPGB_PEN_QEUL	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Qualifying Earning Upper Limit GBR
39	RUN_FINALIZED_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalized Run
40	GPGB_PEN_EVENT1	Character(20)	VARCHAR2(20) NOT NULL	copy of GBR Pension Events
41	GPGB_PEN_A_STATUS1	Character(50)	VARCHAR2(50) NOT NULL	Copy of Pension Applicant Status GBR
42	GPGB_AGG_QEARNING	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Aggregate Qualifying Earning GBR
43	GPGB_PRP_START_DT	Date(10)	DATE	GBR staging date field
44	GPGB_PRP_END_DT	Date(10)	DATE	GBR staging date field
45	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
46	GPGB_EFF_PRC_DT	Date(10)	DATE	GBR process effdt
47	GPGB_PRV_OPTOUT_DT	Date(10)	DATE	GBR previous process effdt
48	GPGB_PEN_FACTOR	Number(2,0)	SMALLINT NOT NULL	Multiplication Factor GBR
49	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
50	GPGB_PRCRN_DATE1	Date(10)	DATE	GBR copy of AutoEnrollment Process run date
51	EFFDT	Date(10)	DATE	Effective Date
52	GPGB_STG_DATE	Date(10)	DATE	GBR staging date field
53	GPGB_QE_PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Qualifying Earning Accumulator GBR
54	GPGB_POSTPONE_JD	Number(3,0)	SMALLINT NOT NULL	Job Holder Postponement for GBR
55	GPGB_POSTPONE_WR	Number(3,0)	SMALLINT NOT NULL	Worker Postponement for GBR
56	GPGB_STG_DT_DFR	Date(10)	DATE	GBR staging date deferment field
57	GPGB_DEFERAL_DT	Date(10)	DATE	GBR date field to store deferal date
58	GPGB_ELG_ASMT_DT	Date(10)	DATE	GBR date field to store the date value on which the employee was assessed and found eligible to be auto enrolled.
59	JOB_ENTRY_DT	Date(10)	DATE	Job Entry Date
60	GPGB_PRV_DEFERL_DT	Date(10)	DATE	GBR date field to store previous deferal date
61	PYMT_DT	Date(10)	DATE	Payment Date
62	GPGB_MAX_DEFER_DT	Date(10)	DATE	Maximum Deferral Date GBR
63	BIRTH_DT	Date(10)	DATE	Actual Birth Date
64	GPGB_AUTOENROLL	Character(1)	VARCHAR2(1) NOT NULL	Auto Enrollment Flag for Pension Default Value: N
65	GPGB_AUTO_REENROLL	Character(1)	VARCHAR2(1) NOT NULL	Auto Re-Enrollment Flag for Pension Default Value: N
66	GPGB_REENR_STG_DT	Date(10)	DATE	Re-Enrollment Staging Date
67	TERMINATION_DT	Date(10)	DATE	Termination Date
68	TRANSFER_ISSUE_DT	Date(10)	DATE	Date the transfer issuance instructions are printed.