XML_TRN_FA_I_VW

(SQL View)
 Index Back

FT Online Facility Data

Tripartite Foundation Online Training Facility Data

SELECT A.COURSE , A.SESSION_NBR , 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.ADDRESS100 , C.POSTAL , C.CITY , C.PHONE1 , C.PHONE2 , C.FAX , C.EMAIL_ADDR , C.MAIL_POSTAL_ESP , C.FISCAL_ID_CD FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRN_FACIL_TBL) B , %Table(TRN_T_FACIL_ESP) C WHERE A.TRN_T_FACILTY3_ESP = B.FACILITY AND B.FACILITY = C.FACILITY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

Prompt Table: CRSE_SESSN_SRCH

2 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 TRN_T_FAC_CIF1_ESP Character(10) VARCHAR2(10) NOT NULL Facility CIF
5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
6 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
7 CITY Character(30) VARCHAR2(30) NOT NULL City
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

9 ADDRESS100 Character(100) VARCHAR2(100) NOT NULL Address 1
10 POSTAL2 Character(12) VARCHAR2(12) NOT NULL Postal Code
11 CITY2 Character(30) VARCHAR2(30) NOT NULL City
12 PHONE1 Character(24) VARCHAR2(24) NOT NULL Phone number field for discounts and perks eligibility file.
13 PHONE2 Character(24) VARCHAR2(24) NOT NULL Phone number field for discounts and perks eligibility file.
14 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

Prompt Table: TRN_T_PHONES_VW

15 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
16 MAIL_POSTAL_ESP Character(100) VARCHAR2(100) NOT NULL Postal Code
17 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code