PAY_CALENDAR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
3	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date
4	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID Prompt Table: PAY_RUN_VW
5	PAY_OFF_CYCLE_CAL	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle Calendar Y/N Table Edit Default Value: N
6	AGGR_ID	Character(6)	VARCHAR2(6) NOT NULL	Aggregate ID
7	PAY_BEGIN_DT	Date(10)	DATE NOT NULL	Pay Period Begin Date
8	CHECK_DT	Date(10)	DATE NOT NULL	Check date.
9	PERIOD_WEEKS	Number(2,0)	SMALLINT NOT NULL	Weeks in this Period
10	PAY_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Pay Period 1=First 2=Second 3=Third 4=Fourth 5=Fifth Default Value: 1
11	PAY_PDS_PER_YEAR	Number(3,0)	SMALLINT NOT NULL	Pay Periods Per Year
12	ACCRUAL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	Accrual Percent
13	REVERSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reverse Accruals Y/N Table Edit Default Value: N
14	PAY_SHEETS_RUN	Character(1)	VARCHAR2(1) NOT NULL	Paysheets Run Y/N Table Edit Default Value: N
15	PAY_PRECALC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Preliminary Calc Run Y/N Table Edit Default Value: N
16	PAY_CALC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Calculation Run Y/N Table Edit Default Value: N
17	PAY_CONFIRM_START	Character(1)	VARCHAR2(1) NOT NULL	Payroll Confirmation Started Y/N Table Edit Default Value: N
18	PAY_CONFIRM_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Confirmation Run Y/N Table Edit Default Value: N
19	PAY_CHECKS_RUN	Character(1)	VARCHAR2(1) NOT NULL	Paychecks Run Y/N Table Edit Default Value: N
20	PAY_OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle Calcs Outstanding Y/N Table Edit Default Value: N
21	PAY_OFF_CYCLE_CLS	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle Closed Y/N Table Edit Default Value: N
22	PAY_DIST_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Distribution Indicator Y/N Table Edit Default Value: N
23	GL_INTERFACE_RUN	Character(1)	VARCHAR2(1) NOT NULL	GL Interface Run Y/N Table Edit Default Value: N
24	SINGLE_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Multiple State Employer Y/N Table Edit Default Value: N
25	CLOSE_DT	Date(10)	DATE	Date Closed Default Value: PAY_CALENDAR.PAY_END_DT
26	ONCYCLE_PAY_END_DT	Date(10)	DATE NOT NULL	Oncycle Pay End Date
27	DED_TAKEN	Character(1)	VARCHAR2(1) NOT NULL	Deductions Taken D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs Default Value: D Prompt Table: DED_TAKEN_BN_VW
28	DED_SUBSET_ID	Character(3)	VARCHAR2(3) NOT NULL	Deduction Subset ID Prompt Table: DED_SUBSET_TBL
29	DED_TAKEN_GENL	Character(1)	VARCHAR2(1) NOT NULL	Specify how general deduction is to be taken. D=Deduction Table Governs N=None R=No Override S=Deduction Table Subset Governs Default Value: D Prompt Table: DED_TAKEN_GN_VW
30	DED_SUBSET_GENL	Character(3)	VARCHAR2(3) NOT NULL	Subset ID for general deductions. Prompt Table: DED_SUBSET_TBL
31	CONFIRM_ERRORS	Character(1)	VARCHAR2(1) NOT NULL	Continue With Errors Y/N Table Edit Default Value: PAYGROUP_TBL.CONFIRM_ERRORS
32	ERR_PAY_END_DT	Date(10)	DATE	Error Pay End Date
33	CPS_RUN	Character(1)	VARCHAR2(1) NOT NULL	Canada Payroll Savings Run Y/N Table Edit Default Value: N
34	GVT_RITS_RUN	Character(1)	VARCHAR2(1) NOT NULL	RITS Interface Run Y/N Table Edit Default Value: N
35	GVT_TSP_RUN	Character(1)	VARCHAR2(1) NOT NULL	TSP Interface Run Y/N Table Edit Default Value: N
36	GVT_TRES_RUN	Character(1)	VARCHAR2(1) NOT NULL	Treasury Interface Run Y/N Table Edit Default Value: N
37	GVT_ACCR_RUN	Character(1)	VARCHAR2(1) NOT NULL	Leave Accrual Run Default Value: N
38	GVT_PAY_YEAR	Number(4,0)	SMALLINT NOT NULL	Pay Year
39	GVT_PP_NBR	Number(3,0)	SMALLINT NOT NULL	Pay Period Number
40	GVT_CY_BEGIN	Character(1)	VARCHAR2(1) NOT NULL	Calendar Year Begins Y/N Table Edit
41	GVT_LY_BEGIN	Character(1)	VARCHAR2(1) NOT NULL	Leave Year Begins Y/N Table Edit
42	GVT_PY_BEGIN	Character(1)	VARCHAR2(1) NOT NULL	Pay Year Begins Y/N Table Edit
43	GVT_FY_BEGIN	Character(1)	VARCHAR2(1) NOT NULL	Fiscal Year Begins Y/N Table Edit
44	GVT_LY_ENDS	Character(1)	VARCHAR2(1) NOT NULL	End of Leave Year Indicator Y/N Table Edit Default Value: N
45	POSN_FUND_RUN	Character(1)	VARCHAR2(1) NOT NULL	CA Payroll Distribution Run N=Not Executed P=In Process Y=Yes (Funding Distributed) Default Value: N
46	CA_GL_INTFC_RUN	Character(1)	VARCHAR2(1) NOT NULL	CA GL Interface Run Y/N Table Edit Default Value: N
47	LD_TL_INTFC_RUN	Character(1)	VARCHAR2(1) NOT NULL	T&L Extract costs Y/N Table Edit Default Value: N
48	OFF_CYCLE_EE_DED	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle Ded Override Y/N Table Edit Default Value: N
49	PDF_PAYCHECK	Character(1)	VARCHAR2(1) NOT NULL	PDF Paychecks Y/N Table Edit Default Value: N
50	PDF_ADVICE	Character(1)	VARCHAR2(1) NOT NULL	PDF Advice Forms Y/N Table Edit Default Value: N
51	PAYCHECKS_RUN	Character(1)	VARCHAR2(1) NOT NULL	Paychecks Y/N Table Edit Default Value: N
52	ADVICE_RUN	Character(1)	VARCHAR2(1) NOT NULL	Advice Forms Y/N Table Edit Default Value: N
53	PROC_DTTMSTAMP	DateTime(26)	TIMESTAMP	Process Date Timestamp