GPTH_SSO110_TMP

(SQL Table)
Index Back

SSO Temp Record for SSO110D

SSO Temp Record for SSO110D DATA_VAL1_DEC SI EE CONTRI MTD DATA_VAL2_DEC SI ER CONTRI MTD DATA_VAL3_DEC SI BASE REPORT MTD

# 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 Record
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 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
22 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
23 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
24 PRD_BGN_DT Date(10) DATE Period Begin Date
25 PRD_END_DT Date(10) DATE Pay Period End Date
26 PYMT_DT Date(10) DATE Payment Date
27 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
28 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
29 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
31 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
32 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
33 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
34 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
35 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
36 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
37 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
38 GPTH_SI_ER_ACCT Character(10) VARCHAR2(10) NOT NULL GPTH_SI_ER_ACCT
39 GPTH_SI_ER_PER Number(5,2) DECIMAL(4,2) NOT NULL Employer Contribution Rate
40 GPTH_SI_BRANCH_NO Character(6) VARCHAR2(6) NOT NULL Social Security Branch Number
41 GPTH_SI_BRANCH_NM Character(50) VARCHAR2(50) NOT NULL Social Security Branch Name
42 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
43 GPTH_PER_TAX_ID Character(20) VARCHAR2(20) NOT NULL Person Tax ID
44 GPTH_SI_EE_ACCT Character(20) VARCHAR2(20) NOT NULL Payee Social Security Number
45 DATA_VAL1_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal
46 DATA_VAL2_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal
47 DATA_VAL3_DEC Signed Number(20,6) DECIMAL(18,6) NOT NULL Data Value - Decimal
48 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number