GPDE_BL

(SQL Table)
Index Back

Pay Balance

Pay Balance

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
7 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
10 SLICE_END_DT Date(10) DATE Element Slice End Date
11 GPDE_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
12 PRD_END_DT Date(10) DATE Pay Period End Date
13 GPDE_AL_RPAY_ENDDT Date(10) DATE Retro Pay End Date
14 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
15 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

Prompt Table: GP_PYENT

16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
19 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
20 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
21 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
22 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
23 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
24 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
25 GPDE_AL_YTD_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Year To Date Amount