PAY_CHECK_REVRS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
4	PAY_END_DT	Date(10)	DATE NOT NULL	Pay Period End Date Prompt Table: PAY_CALENDAR
5	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N
6	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr Prompt Table: PAY_PAGE
7	LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Line Nbr Prompt Table: PAY_LINE
8	SEPCHK	Number(2,0)	SMALLINT NOT NULL	Separate check number. Prompt Table: PAY_CHECK_REVVW
9	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Default Value: PAY_REV_RUNCTL.COMPANY
10	FORM_ID	Character(6)	VARCHAR2(6) NOT NULL	Form Identification
11	PAYCHECK_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Paycheck number.
12	CHECK_DT	Date(10)	DATE	Check date. Prompt Table: PAY_CHK_REVVW
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PAY_CHK_REVVW1
14	DLT_CHECK_REVRS	Character(1)	VARCHAR2(1) NOT NULL	Delete Current Chk Reversal Y/N Table Edit Default Value: N
15	PAYCHECK_ADJUST	Character(1)	VARCHAR2(1) NOT NULL	Paycheck Adjustment Entry N=Reversal Y=Reversal/Adjustment Default Value: N
16	ACCTG_PERIOD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Accounting Period Option for reversal/adjustment C=Current Accounting Period O=Original Accounting Period S=Specified Accounting Period Default Value: O
17	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year Prompt Table: ACCT_FY_VW2
18	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Accounting Period Prompt Table: ACCT_PERIOD_VW2
19	PY_TL_REVRS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payable Time Reversal Type D=Reverse and Generate New Row R=Reverse Only