GPIT_RS01_O_TMP

(SQL Table)
Index Back

Pay Element Summary Temp Table

Temporary Table for Pay Element Summary Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
5 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category
8 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
9 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
10 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
11 GPIT_BL_PR_GROUP Number(2,0) SMALLINT NOT NULL Print Group
12 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
13 GPIT_BL_PR_ORDER Number(6,0) INTEGER NOT NULL Order
14 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
15 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
16 GPIT_PYSL_AMTF1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
17 GPIT_PYSL_AMTF2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Dummy number
18 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
19 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
20 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
21 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
22 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
23 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
24 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
25 NUMBER_OF_EMPL Number(6,0) INTEGER NOT NULL Number of Employees
26 GPIT_AL_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override