GPCH_RP_TX5_HST

(SQL Table)
 Index Back

Tax Temproary Table

This is the Archive (shadow) table used in Data Archiving for the record: GPCH_RP_TX05.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 SLICE_END_DT Date(10) DATE Element Slice End Date
11 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

13 PRD_END_DT Date(10) DATE Pay Period End Date
14 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
15 GPCH_RP_YEAR Date(10) DATE Report Year
16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
17 STATE Character(6) VARCHAR2(6) NOT NULL State
18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
19 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
20 CITY Character(30) VARCHAR2(30) NOT NULL City
21 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code

Prompt Table: GPCH_TX_VILLAGE
Set Control Field: STATE

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