GPCH_RP_TX05

(SQL Table)
 Index Back

Tax Temproary Table

Tax Temproary Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

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 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

Prompt Table: COMPANY_TBL

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 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
17 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code

Prompt Table: GPCH_TX_VILLAGE
Set Control Field: STATE

20 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
21 BEGIN_DT Date(10) DATE Begin Date
22 END_DT Date(10) DATE end date
23 GPCH_RP_CHAR01 Character(6) VARCHAR2(6) NOT NULL Character 01
24 GPCH_RP_CHAR02 Character(8) VARCHAR2(8) NOT NULL Character 02
25 GPCH_RP_CHAR03 Character(8) VARCHAR2(8) NOT NULL Character 03
26 GPCH_RP_CHAR04 Character(6) VARCHAR2(6) NOT NULL Character 04
27 GPCH_RP_CHAR05 Character(6) VARCHAR2(6) NOT NULL Character 05
28 GPCH_RP_CHAR06 Character(6) VARCHAR2(6) NOT NULL Character 06
29 GPCH_RP_CHAR07 Character(6) VARCHAR2(6) NOT NULL Character 07
30 GPCH_RP_CHAR08 Character(6) VARCHAR2(6) NOT NULL Character 08
31 GPCH_RP_CHAR09 Character(6) VARCHAR2(6) NOT NULL Character 09
32 GPCH_RP_CHAR10 Character(6) VARCHAR2(6) NOT NULL Character 10
33 GPCH_RP_CHAR11 Character(6) VARCHAR2(6) NOT NULL Character 11
34 GPCH_RP_CHAR12 Character(6) VARCHAR2(6) NOT NULL Character 12
35 GPCH_RP_CHAR13 Character(6) VARCHAR2(6) NOT NULL Character 13
36 GPCH_RP_CHAR14 Character(6) VARCHAR2(6) NOT NULL Character 14
37 GPCH_RP_CHAR15 Character(6) VARCHAR2(6) NOT NULL Character 15
38 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
39 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
40 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
41 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
42 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
43 GPCH_RP_AMOUNT6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
44 GPCH_RP_AMOUNT7 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
45 GPCH_RP_AMOUNT8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
46 GPCH_RP_AMOUNT9 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 9
47 GPCH_RP_AMOUNT10 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 10
48 GPCH_RP_AMOUNT11 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 11
49 GPCH_RP_AMOUNT12 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 12
50 GPCH_RP_AMOUNT13 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 13
51 GPCH_RP_AMOUNT14 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 14
52 GPCH_RP_AMOUNT15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 15
53 GPCH_RP_AMOUNT16 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 16
54 GPCH_RP_AMOUNT17 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 17
55 GPCH_RP_AMOUNT18 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 18
56 GPCH_RP_AMOUNT19 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 19
57 GPCH_RP_AMOUNT20 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 20
58 GPCH_RP_AMOUNT21 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 21
59 GPCH_RP_AMOUNT22 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 22
60 GPCH_RP_AMOUNT23 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 23
61 GPCH_RP_AMOUNT24 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 24
62 GPCH_RP_AMOUNT25 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 25
63 GPCH_RP_AMOUNT26 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 23
64 GPCH_RP_AMOUNT27 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 27
65 GPCH_RP_AMOUNT28 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 28
66 GPCH_RP_AMOUNT29 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 29
67 GPCH_RP_AMOUNT30 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 30
68 GPCH_RP_AMOUNT31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 31
69 GPCH_RP_AMOUNT32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 32
70 GPCH_RP_AMOUNT33 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 33
71 GPCH_RP_AMOUNT34 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 34
72 GPCH_RP_AMOUNT35 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 35
73 GPCH_RP_AMOUNT36 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 36
74 GPCH_RP_AMOUNT37 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 37
75 GPCH_RP_AMOUNT38 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 38
76 GPCH_RP_AMOUNT39 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount39
77 GPCH_RP_AMOUNT40 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount40
78 GPCH_RP_AMOUNT41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount41
79 GPCH_RP_AMOUNT42 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount42
80 GPCH_RP_AMOUNT43 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount43
81 GPCH_RP_AMOUNT44 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount44
82 GPCH_RP_AMOUNT45 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount45
83 GPCH_RP_AMOUNT46 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount46
84 GPCH_RP_AMOUNT47 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount47
85 GPCH_RP_AMOUNT48 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount48
86 GPCH_RP_AMOUNT49 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount49
87 SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Indicates the source of payable time. S - system generated U - User entered O - Offset
O=Offset
S=System Generated
U=User Reported
88 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
89 TIME_RPTG_TMPLT Character(10) VARCHAR2(10) NOT NULL Time Reporting Template ID