PAY_CAL_OPNVW

#	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_TBL
5	AGGR_ID	Character(6)	VARCHAR2(6) NOT NULL	Aggregate ID
6	PAY_BEGIN_DT	Date(10)	DATE NOT NULL	Pay Period Begin Date
7	CHECK_DT	Date(10)	DATE NOT NULL	Check date.
8	PERIOD_WEEKS	Number(2,0)	SMALLINT NOT NULL	Weeks in this Period
9	PAY_PERIOD	Character(1)	VARCHAR2(1) NOT NULL	Pay Period 1=First 2=Second 3=Third 4=Fourth 5=Fifth Default Value: 1
10	PAY_PDS_PER_YEAR	Number(3,0)	SMALLINT NOT NULL	Pay Periods Per Year
11	ACCRUAL_PCT	Number(6,3)	DECIMAL(5,3) NOT NULL	Accrual Percent
12	REVERSE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Reverse Accruals Y/N Table Edit Default Value: N
13	PAY_SHEETS_RUN	Character(1)	VARCHAR2(1) NOT NULL	Paysheets Run Y/N Table Edit Default Value: N
14	PAY_PRECALC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Preliminary Calc Run Y/N Table Edit Default Value: N
15	PAY_CALC_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Calculation Run Y/N Table Edit Default Value: N
16	PAY_CONFIRM_START	Character(1)	VARCHAR2(1) NOT NULL	Payroll Confirmation Started Y/N Table Edit Default Value: N
17	PAY_CONFIRM_RUN	Character(1)	VARCHAR2(1) NOT NULL	Payroll Confirmation Run Y/N Table Edit Default Value: N
18	PAY_CHECKS_RUN	Character(1)	VARCHAR2(1) NOT NULL	Paychecks Run Y/N Table Edit Default Value: N
19	PAY_OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle Calcs Outstanding Y/N Table Edit Default Value: N
20	PAY_OFF_CYCLE_CLS	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle Closed Y/N Table Edit Default Value: N
21	GL_INTERFACE_RUN	Character(1)	VARCHAR2(1) NOT NULL	GL Interface Run Y/N Table Edit Default Value: N
22	SINGLE_CHECK	Character(1)	VARCHAR2(1) NOT NULL	Multiple State Employer Y/N Table Edit Default Value: N