CRSE_SESS_DATES

(SQL Table)
 Index Back

Training Course Sessions

CRSE_SESS_DATES is a child record of CRSE_SESSN_TBL, and effectively contains the schedule of dates & times for the course session. This record has been introduced to allow training administrators to define course sessions that do not run on consecutive days. It also allows the system to gain more intelligence about when training rooms/instructors are booked. This record is part of the Training Administration module.

  • Related Language Record: CRS_SESSDTS_LNG

  • Parent record: CRSE_SESSN_TBL

    • # 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 CUT_SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Cut Session Nbr

    Default Value: 1

    4 SESSN_START_DT Date(10) DATE Session Start Date
    5 SESSN_END_DT Date(10) DATE Session End Date
    6 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time

    Default Value: COURSE_TBL.DURATION_TIME

    7 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration

    Default Value: COURSE_TBL.DURATION_CONVERTED

    8 DURATION_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Duration Unit

    Default Value: COURSE_TBL.COST_UNIT_CD

    Prompt Table: DT_COST_UNIT_VW

    9 SESSN_START_TIME Time(15) TIMESTAMP NOT NULL Start Time
    10 SESSN_END_TIME Time(15) TIMESTAMP End Time
    11 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

    Prompt Table: %RECNAME_EDIT

    12 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

    Prompt Table: TRN_VENDOR_TBL

    13 FACILITY_NAME Character(30) VARCHAR2(30) NOT NULL Facility Name
    14 ROOM_CD Character(6) VARCHAR2(6) NOT NULL Room Code
    15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    16 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    17 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    18 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    19 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    20 CITY Character(30) VARCHAR2(30) NOT NULL City
    21 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    22 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    23 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    24 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    25 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    26 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    27 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    28 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    29 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    30 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    31 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    32 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    33 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    34 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    35 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    36 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    37 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Default Value: H

    Prompt Table: TD_COST_UNIT_VW

    38 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    39 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    40 FINANCED_COST_FRA Number(19,3) DECIMAL(18,3) NOT NULL Financed Cost
    41 FINANCING_DEPT_FRA Character(10) VARCHAR2(10) NOT NULL Financing Department

    Prompt Table: DEPT_TBL

    42 FINANCING_FUND_FRA Character(6) VARCHAR2(6) NOT NULL Financing Fund

    Prompt Table: TRN_VENDOR_TBL