HCI_LOCATION_VW

(SQL View)
 Index Back

Location View for HCI

Location View for CS HR Campus Integration

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(PHONE_SBR, A) ,A.EXTENSION ,A.FAX ,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 ,%subrec(LOC_TBLMEX_SBR, A) ,A.ESTABID ,A.MESSAGE_TEXT2 ,A.TELE_LOCATION FROM PS_LOCATION_TBL A

# 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_VLD_HR_03

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 FON_ER_ID_MEX Character(12) VARCHAR2(12) NOT NULL FONACOT ID Number
58 FON_OFFICE_MEX Character(12) VARCHAR2(12) NOT NULL FONACOT Office Mexico
59 LOC_TAX_MEX Character(1) VARCHAR2(1) NOT NULL Location Tax Mexico

Y/N Table Edit

Default Value: N

60 LOC_TAX_SPCL_MEX Character(4) VARCHAR2(4) NOT NULL Special Location Tax Mexico
0010=Ciudad Juarez, Chihuahua
61 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

Prompt Table: ESTAB_TBL

62 MESSAGE_TEXT2 Character(100) VARCHAR2(100) NOT NULL Check Cashing Location
63 TELE_LOCATION Character(1) VARCHAR2(1) NOT NULL Telework Location

Y/N Table Edit