XML_TRN_FA_D_VW

(SQL View)
 Index Back

FT Long Distance Facility Data

Tripartite Foundation. Long Distance 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.PHONE1 , C.PHONE2 , C.FAX , C.EMAIL_ADDR , C.MAIL_POSTAL_ESP , C.FISCAL_ID_CD , C.ADDRESS100 , C.POSTAL , C.CITY FROM %Table(TRN_T_SESSN_ESP) A , %Table(TRN_FACIL_TBL) B , %Table(TRN_T_FACIL_ESP) C WHERE A.TRN_T_FACILTY2_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 PHONE1 Character(24) VARCHAR2(24) NOT NULL Phone number field for discounts and perks eligibility file.

Prompt Table: TRN_T_PHONES_VW

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

Prompt Table: TRN_T_PHONES_VW

11 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number

Prompt Table: TRN_T_PHONES_VW

12 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
13 MAIL_POSTAL_ESP Character(100) VARCHAR2(100) NOT NULL Postal Code
14 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code
15 ADDRESS100 Character(100) VARCHAR2(100) NOT NULL Address 1
16 POSTAL2 Character(12) VARCHAR2(12) NOT NULL Postal Code
17 CITY2 Character(30) VARCHAR2(30) NOT NULL City