R_GLX001

(SQL Table)
Index Back

Temp Table - SQR GLX001

This temporary table contains data used when running SQR GLX001.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
2 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
3 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
4 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
5 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
6 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
7 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
8 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
9 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
10 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: JOB.BUSINESS_UNIT