CRSE_SESS_PROVD

(SQL Table)
Index Back

Training Sessions Provider

Administer Training - Provider information and costs for individual course sessions.

  • Parent record: COURSE_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

    Default Value: 0

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

    Prompt Table: TRN_VENDOR_TBL

    4 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    5 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Default Value: H

    Prompt Table: TD_COST_UNIT_VW

    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

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

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: TRN_VENDOR_TBL

    12 CHARGEABLE_SW_FRA Character(1) VARCHAR2(1) NOT NULL Chargeable switch

    Y/N Table Edit

    Default Value: N

    13 CERTIFIED_SW_FRA Character(1) VARCHAR2(1) NOT NULL Certified

    Y/N Table Edit

    Default Value: N

    14 BILLED_FRA Character(1) VARCHAR2(1) NOT NULL Billed

    Y/N Table Edit

    Default Value: N

    15 BILL_PROCESS_DT Date(10) DATE Date Entered
    16 AGREEMENT_DT_FRA Date(10) DATE Agreement Date

    Prompt Table: AGREEMNT_FRA_VW

    17 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: AGREEMT_FRA_VW1

    18 AGREEMENT_NBR_FRA Character(11) VARCHAR2(11) NOT NULL Agreement Number

    Prompt Table: AGREEMENT_FRA