GPTH_SSO110_VW

(SQL View)
 Index Back

SSO Query View for SSO110C/D

SSO Query View DATA_VAL1_DEC SI EE CONTRI MTD DATA_VAL2_DEC SI ER CONTRI MTD DATA_VAL3_DEC SI BASE REPORT MTD

SELECT PROCESS_INSTANCE ,COMPANY ,EMPLID ,EMPL_RCD ,CAL_RUN_ID ,GP_PAYGROUP ,CAL_ID ,GPTH_MONTH ,ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,CITY ,HOUSE_TYPE ,COUNTY ,STATE ,POSTAL ,PHONE ,FAX ,NAME_PREFIX ,%TrimSubstr(FIRST_NAME %Concat ' ' %Concat MIDDLE_NAME, 1, 61) ,FIRST_NAME ,MIDDLE_NAME ,LAST_NAME ,PRD_BGN_DT ,PRD_END_DT ,PYMT_DT ,COUNTRY ,PIN_GROSS_VAL ,PIN_NET_VAL ,CURRENCY_CD ,PAY_ENTITY ,BUSINESS_UNIT ,ESTABID ,SETID_DEPT ,DEPTID ,SETID_LOCATION ,LOCATION ,GPTH_SI_ER_ACCT ,GPTH_SI_ER_PER ,GPTH_SI_BRANCH_NO ,GPTH_SI_BRANCH_NM ,NATIONAL_ID ,GPTH_PER_TAX_ID ,GPTH_SI_EE_ACCT ,DATA_VAL1_DEC ,DATA_VAL2_DEC ,DATA_VAL3_DEC ,SEQ_NUM8 FROM PS_GPTH_SSO110_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
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 GPTH_MONTH Character(7) VARCHAR2(7) NOT NULL GPTH_MONTH
9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
13 CITY Character(30) VARCHAR2(30) NOT NULL City
14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
15 COUNTY Character(30) VARCHAR2(30) NOT NULL County
16 STATE Character(6) VARCHAR2(6) NOT NULL State
17 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
18 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
19 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
20 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
21 GPTH_NAME1 Character(80) VARCHAR2(80) NOT NULL Tax-Payee's First Name
22 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
23 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
24 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
25 PRD_BGN_DT Date(10) DATE Period Begin Date
26 PRD_END_DT Date(10) DATE Pay Period End Date
27 PYMT_DT Date(10) DATE Payment Date
28 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
29 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
30 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
31 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
32 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
34 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
35 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
36 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
37 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
38 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
39 GPTH_SI_ER_ACCT Character(10) VARCHAR2(10) NOT NULL GPTH_SI_ER_ACCT
40 GPTH_SI_ER_PER Number(5,2) DECIMAL(4,2) NOT NULL Employer Contribution Rate
41 GPTH_SI_BRANCH_NO Character(6) VARCHAR2(6) NOT NULL Social Security Branch Number
42 GPTH_SI_BRANCH_NM Character(50) VARCHAR2(50) NOT NULL Social Security Branch Name
43 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
44 GPTH_PER_TAX_ID Character(20) VARCHAR2(20) NOT NULL Person Tax ID
45 GPTH_SI_EE_ACCT Character(20) VARCHAR2(20) NOT NULL Payee Social Security Number
46 DATA_VAL1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal
47 DATA_VAL2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal
48 DATA_VAL3_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal
49 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number