TRN_T_FAC_ESPVW (SQL View)	Index Back
FT Facility Data ESP VW Tripartite Foundation Training Facility Data

TRN_T_FAC_ESPVW

(SQL View)

FT Facility Data ESP VW

Tripartite Foundation Training Facility Data

SELECT B.FACILITY , B.DESCR , C.FISCAL_ID_CD , B.ADDR_FIELD1 %Concat ' ' %Concat B.ADDRESS1 %Concat ', ' %Concat B.ADDR_FIELD2 %Concat '. ' %Concat B.ADDR_FIELD3 %Concat ' ' %Concat B.NUM1 %Concat '-' %Concat B.NUM2 , B.POSTAL , B.CITY , B.COUNTRY , C.PHONE1 FROM PS_TRN_FACIL_TBL B LEFT OUTER JOIN PS_TRN_T_FACIL_ESP C ON B.FACILITY = C.FACILITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code

4 ADDRESS100 Character(100) VARCHAR2(100) NOT NULL Address 1

5 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

6 CITY Character(30) VARCHAR2(30) NOT NULL City

7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

8 PHONE1 Character(24) VARCHAR2(24) NOT NULL Phone number field for discounts and perks eligibility file.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	FISCAL_ID_CD	Character(10)	VARCHAR2(10) NOT NULL	Fiscal Identification Code
4	ADDRESS100	Character(100)	VARCHAR2(100) NOT NULL	Address 1
5	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
6	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
7	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
8	PHONE1	Character(24)	VARCHAR2(24) NOT NULL	Phone number field for discounts and perks eligibility file.