GPTH_COMP_EX_VW

(SQL View)
 Index Back

Company Codes

Company Codes with an extension of the STATE long description. Use this view only when you want to get the long description of the STATE in address, else use PS_COMPANY_TBL instead

SELECT A.COMPANY , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCR_AC , A.DESCRSHORT , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.FEDERAL_EIN , A.FICA_STATUS_EE , A.FICA_STATUS_ER , A.FUT_EXEMPT , A.SUT_EXEMPT , A.SDI_EXEMPT , A.PAYGROUP , A.DFLT_ERN_PROGRAM , A.TERMEE_PR_STOPDAYS , A.PAYSHEET_LINES , A.TAX_REPORT_TYPE , A.COMMON_PAY_ID , A.COMMON_OTH_ID , A.DED_PRIORITY_FED , A.DED_PRIORITY_STATE , A.FED_RSRV_BANK_ID , A.FED_RSRV_BANK_DIST , A.FLSA_REQUIRED , A.FLSA_RULE , A.COMP_POINTS_VALUE , A.CURRENCY_CD , A.TIPS_ESTBLSH_FLD , A.MIN_TIPS_PCT , A.TIPS_ALLOC_METH , A.ERNCD_TIPS_ALLOC , A.TIPS_DELAY_WTHLD , A.TIPS_ADJUST , A.ERNCD_TIPS_ADJUST , A.ERNCD_TIPS_CRED , A.EEO_COMPANY_CD , A.COUNTRY_OTHER , A.ADDRESS1_OTHER , A.ADDRESS2_OTHER , A.ADDRESS3_OTHER , A.ADDRESS4_OTHER , A.CITY_OTHER , A.COUNTY_OTHER , A.STATE_OTHER , A.POSTAL_OTHER , A.NUM1_OTHER , A.NUM2_OTHER , A.HOUSE_TYPE_OTHER , A.ADDR_FIELD1_OTHER , A.ADDR_FIELD2_OTHER , A.ADDR_FIELD3_OTHER , A.IN_CITY_LMT_OTHER , A.GEO_CODE_OTHER , A.FACT_AGE_BEL , A.FACT_CORRECT_BEL , A.FACT_SERVT_BEL , A.FACT_YEAR_BASE_BEL , A.HY_FACT_BEL , A.RIZIV_NUM_BEL , A.TERM_CORRECT_BEL , A.WY_FACT_BEL , A.MY_FACT_BEL , A.YY_FACT_BEL , A.RSZ_GEOCD_BEL , A.RSZ_EMPLR_BEL , A.RVP_NUM_BEL , A.DOSZ_NUM_BEL , A.NIS_NUM_BEL , A.TRADE_NAME_BEL , A.TRADE_REG_BEL , A.LEGAL_APPR_BEL , A.SALARY_LIMIT_BEL , A.IND_COMMITTEE_BEL , A.NACE_CD_BEL , A.OFFICIAL_LANG , A.CLAEYS_SAL_LMT_BEL , A.WCB_FIRM_NBR , A.WCB_RATE_NBR , A.ACCDNT_INS_NBR_CHE , A.COMP_AHV_CHE , A.TRADE_REG_NBR_CHE , A.MED_CHKUP_REQ , A.ACCIDENT_INS , A.SI_ACCIDENT_NUM , A.OECD_REQ , A.TAX_UNIT , A.SIREN_CD_FRA , A.CHECK_DIGIT , A.APE_INDSTRY_CD_FRA , A.BANK_CD , A.BRANCH_EC_CD , A.ACCOUNT_EC_ID , A.LABOR_AGREEMENT , A.BASE_SCHEME_FRA , A.COMPANY_OPTION_FRA , A.EMPLR_TAX_NUM_NLD , A.BUSINESS_DESCR , A.FISCAL_ID_CD , A.DEFAULT_SETID , A.SETID_LOCATION , A.LOCATION , A.TIPS_PROCESSING , A.HP_STATS_INSTN_CD , A.INDUSTRY , A.INDUSTRY_SECTOR , A.OPR_INDUSTRY_OVRD , A.SINGLE_CHECK , A.LEGAL_TYPE , A.PAY_TAXES_THRU_AP , A.SYSTEM_DATA_FLG , A.REG_REGION , A.INST_CODE_AUS , A.CLASS_UNIT_NZL , A.LIABLE_PAY_TAX , A.TEC_COMP_RATECD , A.TPV_COMP_RATECD , A.APS_AGENT_CD_AUS , B.DESCR AS GPTH_STATEDESCR FROM PS_COMPANY_TBL A LEFT JOIN PS_STATE_TBL B ON A.COUNTRY = B.COUNTRY AND A.STATE = B.STATE

  • Related Language Record: GPTH_COMP_V_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Char Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    10 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    11 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    12 CITY Character(30) VARCHAR2(30) NOT NULL City
    13 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    14 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    15 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    16 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    17 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    18 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    19 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    20 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    22 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    23 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    24 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
    25 FICA_STATUS_EE Character(1) VARCHAR2(1) NOT NULL FICA Status-Employee
    E=Exempt
    H=ER FICA Exmpt
    M=Medicare only
    N=Subject

    Default Value: N

    26 FICA_STATUS_ER Character(1) VARCHAR2(1) NOT NULL FICA Status-Employer
    E=Exempt
    M=Medicare only
    N=Subject

    Default Value: N

    27 FUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt from FUT

    Y/N Table Edit

    Default Value: N

    28 SUT_EXEMPT Character(1) VARCHAR2(1) NOT NULL Exempt From SUT

    Y/N Table Edit

    Default Value: N

    29 SDI_EXEMPT Character(1) VARCHAR2(1) NOT NULL Employees' SDI Status
    E=Exempt
    Y=Subject

    Default Value: Y

    30 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    31 DFLT_ERN_PROGRAM Character(3) VARCHAR2(3) NOT NULL Default Earnings Program

    Prompt Table: ERN_PROGRAM_TBL

    32 TERMEE_PR_STOPDAYS Number(2,0) SMALLINT NOT NULL Term. EEs - PR Activity Days

    Default Value: 30

    33 PAYSHEET_LINES Number(3,0) SMALLINT NOT NULL Lines on Paysheet

    Default Value: 15

    34 TAX_REPORT_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Report Type
    2=W-2 or Territories
    M=Non-Employees
    N=None
    P=W-2PR
    R=1099R

    Default Value: 2

    35 COMMON_PAY_ID Character(3) VARCHAR2(3) NOT NULL Common Paymaster ID
    36 COMMON_OTH_ID Character(3) VARCHAR2(3) NOT NULL Other Common ID
    37 DED_PRIORITY_FED Number(3,0) SMALLINT NOT NULL Federal Tax Deduction Priority

    Default Value: 100

    38 DED_PRIORITY_STATE Number(3,0) SMALLINT NOT NULL State Tax Deductn Priority

    Default Value: 110

    39 FED_RSRV_BANK_ID Character(10) VARCHAR2(10) NOT NULL Federal Reserve Bank ID
    40 FED_RSRV_BANK_DIST Number(3,0) SMALLINT NOT NULL Federal Reserve Bank District
    41 FLSA_REQUIRED Character(1) VARCHAR2(1) NOT NULL FLSA required
    N=NO FLSA REQUIRED
    Y=FLSA REQUIRED

    Y/N Table Edit

    Default Value: N

    42 FLSA_RULE Character(1) VARCHAR2(1) NOT NULL FLSA Rule
    F=Always use FLSA Premium
    H=Higher of FLSA/Contractual
    N=No FLSA

    Default Value: H

    43 COMP_POINTS_VALUE Number(19,6) DECIMAL(18,6) NOT NULL Points Value
    44 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    45 TIPS_ESTBLSH_FLD Character(2) VARCHAR2(2) NOT NULL Tip Establishment Field
    JB=Job Business Unit
    JC=Job Company
    JD=Job Dept ID
    JL=Job Location
    PB=Pay Earnings Bus Unit
    PC=Pay Earnings Company
    PD=Pay Earnings DeptID

    Default Value: JL

    46 MIN_TIPS_PCT Number(9,5) DECIMAL(8,5) NOT NULL Minimum Tips Percent

    Default Value: 8

    47 TIPS_ALLOC_METH Character(1) VARCHAR2(1) NOT NULL Tips Allocation Method
    F=Good Faith (Custom)
    H=Hours Worked
    R=Gross Receipts

    Default Value: R

    48 ERNCD_TIPS_ALLOC Character(3) VARCHAR2(3) NOT NULL Tips Allocation Earnings Code

    Prompt Table: EARNINGS_TBL

    49 TIPS_DELAY_WTHLD Character(1) VARCHAR2(1) NOT NULL Delay Withholding of Taxes

    Y/N Table Edit

    Default Value: N

    50 TIPS_ADJUST Character(1) VARCHAR2(1) NOT NULL Adjust to Minimum Wage

    Y/N Table Edit

    Default Value: Y

    51 ERNCD_TIPS_ADJUST Character(3) VARCHAR2(3) NOT NULL Min Wage Adjustment Earns Code

    Prompt Table: EARNINGS_TBL

    52 ERNCD_TIPS_CRED Character(3) VARCHAR2(3) NOT NULL Tip Credit Earnings Code

    Prompt Table: EARNINGS_TBL

    53 EEO_COMPANY_CD Character(7) VARCHAR2(7) NOT NULL EEO Company Code
    54 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    55 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    56 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    57 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    58 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    59 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    60 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    61 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    62 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    63 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    64 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    65 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    66 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    67 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    68 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    69 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    70 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    71 FACT_AGE_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Factor Age
    72 FACT_CORRECT_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Correction Factor
    73 FACT_SERVT_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Factor Seniority
    74 FACT_YEAR_BASE_BEL Signed Number(12,7) DECIMAL(10,7) NOT NULL Factor Yearly Base
    75 HY_FACT_BEL Number(11,6) DECIMAL(10,6) NOT NULL Hour/Year Factor
    76 RIZIV_NUM_BEL Character(10) VARCHAR2(10) NOT NULL RIZIV is a Dutch acronym for (Rijksdienst voor Sociale Zekerheid). The French acronym is INAMI (Institue National d'Assurance Maladie Invalidite).
    77 TERM_CORRECT_BEL Signed Number(5,1) DECIMAL(3,1) NOT NULL Number of Months to Reduce
    78 WY_FACT_BEL Number(11,7) DECIMAL(10,7) NOT NULL Week/Year Factor
    79 MY_FACT_BEL Number(12,7) DECIMAL(11,7) NOT NULL Month/Year factor
    80 YY_FACT_BEL Number(11,7) DECIMAL(10,7) NOT NULL Year/Year Factor
    81 RSZ_GEOCD_BEL Character(10) VARCHAR2(10) NOT NULL Geografic Location for the NOSS 'National Office for Social Security'.
    82 RSZ_EMPLR_BEL Character(20) VARCHAR2(20) NOT NULL NOSS - National Office for Social Security The Dutch acronym is RSZ (Rijksdienst voor Sociale Zekerheid) The French acronym is ONSS ('l Office National de Securite de Sociale)
    83 RVP_NUM_BEL Character(10) VARCHAR2(10) NOT NULL Federal Pension Institute
    84 DOSZ_NUM_BEL Character(10) VARCHAR2(10) NOT NULL Overseas Soc Ins Inst
    85 NIS_NUM_BEL Character(25) VARCHAR2(25) NOT NULL Statistics Institute
    86 TRADE_NAME_BEL Character(35) VARCHAR2(35) NOT NULL Company Trade Name
    87 TRADE_REG_BEL Character(30) VARCHAR2(30) NOT NULL Registration for Trade
    88 LEGAL_APPR_BEL Character(2) VARCHAR2(2) NOT NULL Legal Entity
    01=Inc.
    02=Limited Liability Ownership
    03=Limited Liability Corporation
    04=Cooperative Ownership
    05=Particular Type Ownership
    06=Non-profit Organization
    07=Other
    89 SALARY_LIMIT_BEL Character(1) VARCHAR2(1) NOT NULL Salary Limit

    Y/N Table Edit

    Default Value: N

    90 IND_COMMITTEE_BEL Character(3) VARCHAR2(3) NOT NULL The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level,

    Prompt Table: UNION_TBL

    91 NACE_CD_BEL Character(10) VARCHAR2(10) NOT NULL The NACE Code is used for a generic systematic classification of companies within the European community. Format: AB12,34567 A - Section B - Subsection 12 - Division 345 - Group 6 - Class 7 - Subclass
    92 OFFICIAL_LANG Character(3) VARCHAR2(3) NOT NULL The Official Language is used by Belgium to track the official language for the company and employees. This language code indicates in which language the official reports and communication between company and employees should occur.

    Prompt Table: LANGUAGE_CD_VW

    93 CLAEYS_SAL_LMT_BEL Number(19,6) DECIMAL(18,6) NOT NULL Claeys Salary Limit
    94 WCB_FIRM_NBR Character(10) VARCHAR2(10) NOT NULL WCB Firm Number
    95 WCB_RATE_NBR Character(10) VARCHAR2(10) NOT NULL WCB Rate Number
    96 ACCDNT_INS_NBR_CHE Character(15) VARCHAR2(15) NOT NULL This field holds the Accident Insurance Number for Swiss Companies.
    97 COMP_AHV_CHE Character(6) VARCHAR2(6) NOT NULL This field holds the AHV Number for Swiss Companies.
    98 TRADE_REG_NBR_CHE Character(16) VARCHAR2(16) NOT NULL This field holds the Trade Registry Number for Swiss Companies.
    99 MED_CHKUP_REQ Character(1) VARCHAR2(1) NOT NULL Medical Checkup Required

    Y/N Table Edit

    Default Value: Y

    100 ACCIDENT_INS Character(15) VARCHAR2(15) NOT NULL Accident Insurance

    Prompt Table: ACCDT_INS_TBL

    101 SI_ACCIDENT_NUM Character(15) VARCHAR2(15) NOT NULL Social Insurance Accident #
    102 OECD_REQ Character(1) VARCHAR2(1) NOT NULL OECD Permission Required

    Y/N Table Edit

    Default Value: N

    103 TAX_UNIT Character(6) VARCHAR2(6) NOT NULL Tax Unit
    104 SIREN_CD_FRA Character(9) VARCHAR2(9) NOT NULL SIREN Code
    105 CHECK_DIGIT Character(2) VARCHAR2(2) NOT NULL Check Digit
    106 APE_INDSTRY_CD_FRA Character(5) VARCHAR2(5) NOT NULL APE Code

    Prompt Table: APE_INDSTRY_FRA

    107 BANK_CD Character(11) VARCHAR2(11) NOT NULL Bank ID

    Prompt Table: BANK_TBL_FRA_VW

    108 BRANCH_EC_CD Character(17) VARCHAR2(17) NOT NULL Bank Branch ID
    109 ACCOUNT_EC_ID Character(35) VARCHAR2(35) NOT NULL Account Number used in banking.
    110 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG
    Set Control Field: REG_REGION

    111 BASE_SCHEME_FRA Character(3) VARCHAR2(3) NOT NULL Mandatory Base Scheme

    Prompt Table: BSE_SCH_FRA_TBL

    112 COMPANY_OPTION_FRA Character(1) VARCHAR2(1) NOT NULL Company Option - FRA
    P=Partial
    T=Total
    113 EMPLR_TAX_NUM_NLD Number(9,0) DECIMAL(9) NOT NULL Federal Employer Tax ID
    114 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
    115 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code
    116 DEFAULT_SETID Character(5) VARCHAR2(5) NOT NULL Default SetID

    Default Value: COMPANY_TBL.COMPANY

    Prompt Table: SETID_TBL

    117 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

    Prompt Table: SET_LOC_VLD_VW

    118 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SET_LOC_VW

    119 TIPS_PROCESSING Character(1) VARCHAR2(1) NOT NULL Tips Processing

    Y/N Table Edit

    Default Value: N

    120 HP_STATS_INSTN_CD Number(8,0) INTEGER NOT NULL Stats Reporting Institution
    121 INDUSTRY Character(4) VARCHAR2(4) NOT NULL Industry
    CORE=Core
    EDUC=Education
    FNSV=Financial Services
    GOVT=Government
    HLTH=Health Care
    RETL=Retail
    TRAN=Transportation
    UTIL=Utilities

    Default Value: CORE

    122 INDUSTRY_SECTOR Character(4) VARCHAR2(4) NOT NULL Industry Sector
    CORE=Core
    PBSC=Public Sector
    USFG=US Federal Government

    Default Value: CORE

    123 OPR_INDUSTRY_OVRD Character(1) VARCHAR2(1) NOT NULL Override Operator Industry

    Y/N Table Edit

    Default Value: Y

    124 SINGLE_CHECK Character(1) VARCHAR2(1) NOT NULL Multiple State Employer

    Y/N Table Edit

    Default Value: Y

    125 LEGAL_TYPE Character(4) VARCHAR2(4) NOT NULL Legal Entity for Company

    Prompt Table: SET_LEG_TYPE_VW

    126 PAY_TAXES_THRU_AP Character(1) VARCHAR2(1) NOT NULL Pay Taxes through AP

    Y/N Table Edit

    Default Value: Y

    127 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N

    128 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_STANDARD_VW

    129 INST_CODE_AUS Character(4) VARCHAR2(4) NOT NULL This code represents the unique ID of the Institute. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    130 CLASS_UNIT_NZL Character(5) VARCHAR2(5) NOT NULL This field is used in the calculation of ARCI premiums.

    Prompt Table: CLS_UNT_TBL_NZL

    131 LIABLE_PAY_TAX Character(1) VARCHAR2(1) NOT NULL Tax Liability Flag

    Y/N Table Edit

    Default Value: N

    132 TEC_COMP_RATECD Character(6) VARCHAR2(6) NOT NULL TEC Rate Code - Salary Packaging

    Prompt Table: PKG_COMP_RCD_VW

    133 TPV_COMP_RATECD Character(6) VARCHAR2(6) NOT NULL TPV Rate Code - Salary Packaging

    Prompt Table: PKG_COMP_RCD_VW

    134 APS_AGENT_CD_AUS Number(3,0) SMALLINT NOT NULL Australia Public Service (APS) Agency Code.
    135 GPTH_STATEDESCR Character(30) VARCHAR2(30) NOT NULL Long description of State