LOC_TBL_EF_VW

(SQL View)
 Index Back

Company Site Locations

This table has been synchronized with the ERP Table definition. Any changes will need to be applied to the LOCATION_TBL definition in the ERP database. LOCATION_TBL is an edit table. Use it to record information about your company's work sites.

SELECT A.SETID , A.LOCATION , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCR_AC , A.DESCRSHORT , A.BUILDING , A.FLOOR , A.SECTOR , A.JURISDICTION , A.ATTN_TO , %subrec(address_sbr,a) , %subrec(bus_phone_sbr,a) , A.SETID_SALARY , A.SAL_ADMIN_PLAN , A.LANG_CD , A.REG_REGION , A.HOLIDAY_SCHEDULE , %subrec(loc_tblusa_sbr,a) , %subrec(loc_tblcan_sbr,a) , %subrec(loc_tblger_sbr,a) , %subrec(loc_tbluk_sbr,a) , %subrec(loc_tbl_fed_sbr,a) , %subrec(loc_tblesp_sbr,a) , A.LABEL_FORMAT_ID2 , A.LABEL_FORMAT_ID3 , A.USG_LBL_FORMAT_ID , A.ESTABID , A.COMMENTS_2000 FROM PS_LOCATION_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LOCATION_TBL B WHERE B.SETID = A.SETID AND B.LOCATION = A.LOCATION AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: LOCATION_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_LOC_VLD_VW

    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR_AC Character(30) VARCHAR2(30) NOT NULL Alternate Char Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 BUILDING Character(10) VARCHAR2(10) NOT NULL Building Nbr
    9 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor Nbr
    10 SECTOR Character(10) VARCHAR2(10) NOT NULL Sector
    11 JURISDICTION Character(5) VARCHAR2(5) NOT NULL Jurisdiction
    12 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention
    13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    18 CITY Character(30) VARCHAR2(30) NOT NULL City
    19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    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 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    30 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    31 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    32 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
    33 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    34 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

    Prompt Table: SET_SAL_LOC_VW

    35 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: %SAL_PLN_PRMPT2

    36 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    CFR=Canadian French
    DAN=Danish
    DUT=Dutch
    ENG=English
    ESP=Spanish
    FRA=French
    GER=German
    GRK=Greek
    INE=International English
    ITA=Italian
    JPN=Japanese
    KOR=Korean
    POR=Portuguese
    SVE=Swedish
    THA=Thai
    ZHS=Simplified Chinese
    ZHT=Traditional Chinese
    37 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    38 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule

    Prompt Table: HOLIDAY_TBL

    39 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

    40 CAN_CMA Character(2) VARCHAR2(2) NOT NULL Canadian Census Metropol Area

    Prompt Table: CAN_CMA_XLAT_VW

    41 CAN_OEE_AREACD Character(2) VARCHAR2(2) NOT NULL CEC Management Area
    01=Toronto Management Area
    02=Hamilton Management Area
    03=Niagra Management Area
    04=Brant Haldimand, Norfolk Area
    05=Windsor Management Area
    06=London Management Area
    07=Kitchener Management Area
    08=Mississauga Management Area
    09=Brampton Management Area
    10=York Management Area
    11=Georgian Bay Management Area
    12=Kenora Management Area
    13=Timmins Management Area
    14=Slt.St.Marie Management Area
    15=Sudbury Management Area
    16=North Bay Management Area
    17=Pembroke Management Area
    18=Ottawa Management Area
    19=Cornwall Management Area
    20=Kingston Management Area
    21=Belleville Management Area
    22=Peterborough Management Area
    23=Oshawa Management Area
    42 GEOLOC_CODE Character(10) VARCHAR2(10) NOT NULL Geographical Location Code
    43 OFFICE_TYPE Character(1) VARCHAR2(1) NOT NULL Office Type
    0=N/A - No Public Svc/Lang Rqmt
    1=Both Languages for H.O./Cntrl
    2=Both Languages/Signfcnt Demand
    44 NCR_SW_CAN Character(1) VARCHAR2(1) NOT NULL 17 Dec. 1998 - S. Binpal Identifier for NCR location. Added for Canada Official Languages Reporting Mods.

    Y/N Table Edit

    45 TBS_OFFICE_CD_CAN Character(10) VARCHAR2(10) NOT NULL 17 Dec. 1998 - S. Binpal Treasury Board's Office code for the location. Added for Canada Official Languages Reporting Mods.
    46 SPK_COMM_ID_GER Character(9) VARCHAR2(9) NOT NULL Spokesmen Committee ID

    Prompt Table: SPK_COMM_GER

    47 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tariff Area

    Prompt Table: TARIFF_AREA_GER

    48 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff
    01=Metal Processing
    02=Banking
    03=Building and Civil Engineering
    04=Clothing Industry
    05=Chemical Industry
    06=Printing Industry
    07=Retail Trade
    08=Fossil Oil and Gas Extraction
    09=Glass Industry
    10=Wholesale and Foreign Trade
    11=Wood Processing
    12=Rubber Processing
    13=Ceramics
    14=Agriculture
    15=Leather Processing
    16=Public Sector
    17=Paper Industry
    18=Paper Processing
    19=Sawing Industry
    20=German Seaports
    21=Hard-Coal Mining
    22=Textile Industry
    23=Insurance
    24=Housing Industry
    25=Periodical Publishers
    26=Newspaper Publishers
    27=Tobacco Industry
    49 INDUST_INSP_ID_GER Character(4) VARCHAR2(4) NOT NULL Industrial Inspection ID

    Prompt Table: INDUST_INSP_GER

    50 NI_REPORT_SW_UK Character(1) VARCHAR2(1) NOT NULL Northern Ireland Reportable

    Y/N Table Edit

    51 GVT_GEOLOC_CD Character(9) VARCHAR2(9) NOT NULL Geographic Location Code

    Prompt Table: GVT_GEOLOC_TBL

    52 GVT_DESIG_AGENT Character(4) VARCHAR2(4) NOT NULL Designated Agent Code

    Prompt Table: GVT_DESIG_AGENT

    53 MATRICULA_NBR Number(5,0) INTEGER NOT NULL Matricula Number
    54 LABEL_FORMAT_ID2 Character(30) VARCHAR2(30) NOT NULL Carton Label Format ID
    55 LABEL_FORMAT_ID3 Character(30) VARCHAR2(30) NOT NULL Ship Container Label Format ID
    56 USG_LBL_FORMAT_ID Character(30) VARCHAR2(30) NOT NULL Item Usage Label Format
    57 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    58 COMMENTS_2000 Long Character(32700) CLOB Comments Text