GPSG_LEAVE_LIAB

(SQL Table)
Index Back

GP GL Transaction Interface

GL Interface Transaction for GP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 GROUPING_CODE Character(15) VARCHAR2(15) NOT NULL Identifier (name) used to group a number of elements (earnings or deductions) that can be treated equally (posted to the same account) for GL purposes.
10 PIN_CHART1_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
11 PIN_CHART2_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
12 PIN_CHART3_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value`
13 PIN_CHART4_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
14 PIN_CHART5_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
15 PIN_CHART6_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
16 PIN_CHART7_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
17 PIN_CHART8_VAL Character(15) VARCHAR2(15) NOT NULL pin chart field value
18 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
19 POSTING_DATE Date(10) DATE Posting Date
20 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
21 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code