GPCH_RP_0002

(SQL Table)
Index Back

Result Values

Result Values

# 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 Record
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 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 SLICE_END_DT Date(10) DATE Element Slice End Date
9 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
11 PRD_END_DT Date(10) DATE Pay Period End Date
12 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
13 GPCH_RP_YEAR Date(10) DATE Report Year
14 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
15 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
16 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
17 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
18 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
19 GPCH_RP_AMOUNT6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
20 GPCH_RP_AMOUNT7 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
21 GPCH_RP_AMOUNT8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
22 GPCH_RP_AMOUNT9 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 9
23 GPCH_RP_AMOUNT10 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 10
24 GPCH_RP_AMOUNT11 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 11
25 GPCH_RP_AMOUNT12 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 12
26 GPCH_RP_AMOUNT13 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 13
27 GPCH_RP_AMOUNT14 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 14
28 GPCH_RP_AMOUNT15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 15
29 GPCH_RP_AMOUNT16 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 16
30 GPCH_RP_AMOUNT17 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 17