BAL_ADJ_CHK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
3	BALANCE_ID	Character(2)	VARCHAR2(2) NOT NULL	Balance ID Prompt Table: BALANCE_ID_TBL
4	BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balances for Year Prompt Table: BALANCE_YR_VW
5	BAL_ADJ_SEQ	Number(3,0)	SMALLINT NOT NULL	Balance Adjust Sequence Number
6	DT_ENTERED	Date(10)	DATE NOT NULL	Date Entered
7	BALANCE_QTR	Number(3,0)	SMALLINT NOT NULL	Balances for Quarter Prompt Table: BALANCE_ID_QTR
8	BALANCE_PERIOD	Number(3,0)	SMALLINT NOT NULL	Balances for Period Prompt Table: BALANCE_ID_DEF
9	TOTAL_GROSS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Gross YTD
10	TOT_GRS_YTD_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Gross YTD Adjusted
11	TOT_GRS_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Gross Adjustment
12	TOTAL_TAXES_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Taxes YTD
13	TOT_TAX_YTD_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Taxes YTD Adjusted
14	TOT_TAX_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Taxes Adjustment
15	TOTAL_DEDNS_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Deductions YTD
16	TOT_DED_YTD_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Deductions YTD Adjusted
17	TOT_DED_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Total Deductions Adjustment
18	NET_PAY_YTD	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Net Pay YTD
19	NET_PAY_YTD_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Net Pay YTD Adjusted
20	NET_PAY_ADJ	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Net Pay Adjustment
21	ADJ_REASON	Character(50)	VARCHAR2(50) NOT NULL	Adjustment Reason