TRN001_VW

(SQL View)
 Index Back

View for Bus Comp Panel Grp

View for Bus Comp Panel Grp

SELECT A.EMPLID , A.COURSE_START_DT , A.COURSE , A.SESSION_NBR , A.COURSE_TITLE , A.E_ADDR_TYPE , A.EMAIL_ADDR , A.COURSE_END_DT , A.SESSN_START_TIME , A.SESSN_END_TIME , A.LETTER_CD , A.TRN001_AE_SW , A.CHAR_START_DT , A.CHAR_END_DT , A.CHAR_START_TIME , A.CHAR_END_TIME , C.DESCR , D.ROOM_NBR , D.BUILDING , D.FLOOR , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.CITY , B.COUNTY , B.STATE , B.POSTAL , B.COUNTRY FROM PS_TRN001_TAO A , PS_CRSE_SESS_DATES B , PS_TRN_FACIL_TBL C , PS_TRN_ROOM_TBL D WHERE A.COURSE = B.COURSE AND A.SESSION_NBR = B.SESSION_NBR AND B.CUT_SESSION_NBR = '1' AND B.FACILITY = C.FACILITY AND B.ROOM_CD = D.ROOM_CD AND C.FACILITY = D.FACILITY

  • Related Language Record: TRN001_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 COURSE_START_DT Date(10) DATE Course Start Date
    3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
    4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
    5 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    6 E_ADDR_TYPE Character(4) VARCHAR2(4) NOT NULL Email Address Type. Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
    BUSN=Business
    CAMP=Campus
    DORM=Dormitory
    HOME=Home
    OTHR=Other
    7 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email Address
    8 COURSE_END_DT Date(10) DATE Course End Date
    9 SESSN_START_TIME Time(15) TIMESTAMP Start Time
    10 SESSN_END_TIME Time(15) TIMESTAMP End Time
    11 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code
    12 TRN001_AE_SW Character(1) VARCHAR2(1) NOT NULL Updated by Application Engine?

    Y/N Table Edit

    Default Value: N

    13 CHAR_START_DT Character(10) VARCHAR2(10) NOT NULL Session Start Date
    14 CHAR_END_DT Character(10) VARCHAR2(10) NOT NULL Session End Date
    15 CHAR_START_TIME Character(6) VARCHAR2(6) NOT NULL Session Start Time
    16 CHAR_END_TIME Character(6) VARCHAR2(6) NOT NULL Session End Time
    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 ROOM_NBR Character(30) VARCHAR2(30) NOT NULL Room Number
    19 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #
    20 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #
    21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    25 CITY Character(30) VARCHAR2(30) NOT NULL City
    26 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    27 STATE Character(6) VARCHAR2(6) NOT NULL State
    28 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    29 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country