GPTH_RPT_PIT_VW

(SQL View)
 Index Back

PIT Report View

PIT Report View

SELECT PROCESS_INSTANCE , EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , GP_RPT_KEY , PIN_NUM , ' ' , INSTANCE , NAME_PREFIX , GPTH_NAME1 , FIRST_NAME , MIDDLE_NAME , LAST_NAME , BIRTHDATE , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , HOUSE_TYPE , COUNTY , STATE , POSTAL , 0 , COUNTRY , PHONE , EXTENSION , ' ' , HOME_PHONE , GPTH_HOME_EXT , NATIONAL_ID , GPTH_PER_TAX_ID , GPTH_SPO_STATUS , GPTH_TX_SPO_IND , GPTH_TX_PAFA , GPTH_TX_PAMOT , GPTH_TX_SPO_FA , GPTH_TX_SPO_MOT , GPTH_TX_HI_PAFA , GPTH_TX_HI_PAMO , GPTH_TX_HI_SPOFA , GPTH_TX_HI_SPOMO , GPTH_FHOUSE_PRICE , GPTH_FA_ID , GPTH_M_ID , GPTH_FI_ID , GPTH_MI_ID , MAR_STATUS , GPTH_SPIN , GPTH_STIN , GPTH_SP_BIRTHDATE , GPTH_SPREFIX , GPTH_NAME2 , GPTH_SPO_FIRSTNAME , GPTH_SPO_LASTNAME , OFF_CYCLE , PRD_BGN_DT , PRD_END_DT , SEG_BGN_DT , SEG_END_DT , PYMT_DT , CAL_PRD_ID , PIN_GROSS_VAL , PIN_NET_VAL , CURRENCY_CD , CUR_RT_TYPE , RUN_TYPE , PAY_ENTITY , BUSINESS_UNIT , COMPANY , ESTABID , SETID_DEPT , DEPTID , SETID_LOCATION , LOCATION , GPTH_GOV , GPTH_SEQ_NUM , GPTH_TAX_ID , GPTH_TAX_BRANCH , GPTH_TAX_ID_L , 0 , ' ' , ' ' , ACM_FROM_DT , ACM_THRU_DT , SLICE_BGN_DT , SLICE_END_DT , CALC_RSLT_VAL , BASE_RSLT_VAL , RATE_RSLT_VAL , UNIT_RSLT_VAL , PCT_RSLT_VAL , RSLT_ADD_ARR , RSLT_NOT_TKN , RSLT_PAYBK , RSLT_XFER_VAL , BASE_ADJ_VAL , CALC_ADJ_VAL , UNIT_ADJ_VAL , USER_ADJ_VAL , USER_KEY1 , USER_KEY2 , PIN_TYPE , PIN_NM , PIN_CODE , PIN_CUSTOM1 , GPTH_TX_PP , GPTH_TX_PP_ID , GPTH_TX_SPP , GPTH_TX_SPP_ID , DT_OF_DEATH , GPTH_PF_TYPE , GPTH_CHILD1_ID , GPTH_CHILD2_ID , GPTH_CHILD3_ID , GPTH_STUDENT1_ID , GPTH_STUDENT2_ID , GPTH_STUDENT3_ID FROM PS_GPTH_PIT_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
11 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
12 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
13 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
14 GPTH_NAME1 Character(80) VARCHAR2(80) NOT NULL Tax-Payee's First Name
15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
16 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
17 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
18 BIRTHDATE Date(10) DATE Date of Birth
19 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
20 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
21 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
22 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
23 CITY Character(30) VARCHAR2(30) NOT NULL City
24 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
29 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
30 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
31 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
32 GPTH_HOME_PHONE_TY Character(4) VARCHAR2(4) NOT NULL Phone Type
33 HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Phone #
34 GPTH_HOME_EXT Character(6) VARCHAR2(6) NOT NULL Phone number extension
35 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
36 GPTH_PER_TAX_ID Character(20) VARCHAR2(20) NOT NULL Person Tax ID
37 GPTH_SPO_STATUS Character(3) VARCHAR2(3) NOT NULL Marriy Status
DIE=Died during tax year
DIV=Divorce during tax year
MAR=Married during tax year
NA=Not available
WHO=Married for the whole tax year
38 GPTH_TX_SPO_IND Number(1,0) SMALLINT NOT NULL Claim spouse allowance

Default Value: 0

39 GPTH_TX_PAFA Character(1) VARCHAR2(1) NOT NULL Declare for Payee's Father

Y/N Table Edit

Default Value: N

40 GPTH_TX_PAMOT Character(1) VARCHAR2(1) NOT NULL Declare for Payee's Mother

Y/N Table Edit

Default Value: N

41 GPTH_TX_SPO_FA Character(1) VARCHAR2(1) NOT NULL Declare for Spouse's Father

Y/N Table Edit

Default Value: N

42 GPTH_TX_SPO_MOT Character(1) VARCHAR2(1) NOT NULL Declare for Spouse's Mother

Y/N Table Edit

Default Value: N

43 GPTH_TX_HI_PAFA Character(1) VARCHAR2(1) NOT NULL Declare HI for Payee's Father
44 GPTH_TX_HI_PAMO Character(1) VARCHAR2(1) NOT NULL Declare HI for Payee's Mother
45 GPTH_TX_HI_SPOFA Character(1) VARCHAR2(1) NOT NULL Declare HI for Spouse's Father
46 GPTH_TX_HI_SPOMO Character(1) VARCHAR2(1) NOT NULL Declare HI for Spouse's Mother
47 GPTH_FHOUSE_PRICE Number(12,2) DECIMAL(11,2) NOT NULL First House, house price
48 GPTH_FA_ID Character(13) VARCHAR2(13) NOT NULL Father ID No
49 GPTH_M_ID Character(20) VARCHAR2(20) NOT NULL Mother's National ID
50 GPTH_FI_ID Character(20) VARCHAR2(20) NOT NULL National ID of Father in law
51 GPTH_MI_ID Character(20) VARCHAR2(20) NOT NULL National ID Mother in law
52 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
53 GPTH_SPIN Character(13) VARCHAR2(13) NOT NULL National ID of Spouse
54 GPTH_STIN Character(13) VARCHAR2(13) NOT NULL Tax ID No of Spouse
55 GPTH_SP_BIRTHDATE Date(10) DATE Spouse's Birthdate
56 GPTH_SPREFIX Character(10) VARCHAR2(10) NOT NULL Spouse Name Prefix
57 GPTH_NAME2 Character(80) VARCHAR2(80) NOT NULL Tax-Payee's First Name
58 GPTH_SPO_FIRSTNAME Character(30) VARCHAR2(30) NOT NULL Spouse's First Name
59 GPTH_SPO_LASTNAME Character(30) VARCHAR2(30) NOT NULL Spouse's Last Name
60 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
61 PRD_BGN_DT Date(10) DATE Period Begin Date
62 PRD_END_DT Date(10) DATE Pay Period End Date
63 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
64 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
65 PYMT_DT Date(10) DATE Payment Date
66 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID
67 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
68 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
69 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
70 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
71 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
72 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
73 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
74 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
75 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
76 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
77 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
78 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
79 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
80 GPTH_GOV Character(1) VARCHAR2(1) NOT NULL This field represents that if the report is an Government report
81 GPTH_SEQ_NUM Character(6) VARCHAR2(6) NOT NULL Sequence number for tax report
82 GPTH_TAX_ID Character(10) VARCHAR2(10) NOT NULL Tax identification number
83 GPTH_TAX_BRANCH Character(6) VARCHAR2(6) NOT NULL Tax branch number
84 GPTH_TAX_ID_L Character(13) VARCHAR2(13) NOT NULL Tax identification number 13
85 GPTH_SI_ER_PER Number(5,2) DECIMAL(4,2) NOT NULL Employer Contribution Rate
86 GPTH_SI_ACCT Character(10) VARCHAR2(10) NOT NULL This field will be used to store company social security account information.
87 GPTH_SI_BRANCH_NO Character(6) VARCHAR2(6) NOT NULL Social Security Branch Number
88 ACM_FROM_DT Date(10) DATE From Date
89 ACM_THRU_DT Date(10) DATE Through Date
90 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
91 SLICE_END_DT Date(10) DATE Element Slice End Date
92 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
93 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
94 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
95 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
96 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
97 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
98 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken
99 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result
100 RSLT_XFER_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Bank Transfer Value of Deduct
101 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
102 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
103 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
104 USER_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL User Adjustment Value
105 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
106 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
107 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
108 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
109 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
110 PIN_CUSTOM1 Character(20) VARCHAR2(20) NOT NULL Customer FIelds
111 GPTH_TX_PP Character(1) VARCHAR2(1) NOT NULL Payee's party donation
112 GPTH_TX_PP_ID Character(3) VARCHAR2(3) NOT NULL Payee's party donation - Party ID
113 GPTH_TX_SPP Character(1) VARCHAR2(1) NOT NULL Payee's spouse party donation
114 GPTH_TX_SPP_ID Character(3) VARCHAR2(3) NOT NULL Payee's spouse party donation - Party ID
115 DT_OF_DEATH Date(10) DATE Date of Death
116 GPTH_PF_TYPE Character(3) VARCHAR2(3) NOT NULL Provident Fund Type for GP Thailand
CPF=Company Provident Fund
GPF=Goverment Provident Fund
NSF=National Savings Fund
PSF=Private School Teacher PF
117 GPTH_CHILD1_ID Character(13) VARCHAR2(13) NOT NULL Child ID No
118 GPTH_CHILD2_ID Character(13) VARCHAR2(13) NOT NULL Child ID No
119 GPTH_CHILD3_ID Character(13) VARCHAR2(13) NOT NULL Child ID No
120 GPTH_STUDENT1_ID Character(13) VARCHAR2(13) NOT NULL Student ID No
121 GPTH_STUDENT2_ID Character(13) VARCHAR2(13) NOT NULL Student ID No
122 GPTH_STUDENT3_ID Character(13) VARCHAR2(13) NOT NULL Student ID No