TRN_T_SESSN_ESP

(SQL Table)
 Index Back

Tripartite Foundation Session

Tripartite Foundation data for courses and sessions.

  • Related Language Record: TRN_T_SESSN_LNG

    • # 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 TRN_T_ACTION_ESP Character(5) VARCHAR2(5) NOT NULL Training Action

    Prompt Table: TRN_T_ACT_ESP

    4 TRN_T_GROUP_ESP Character(5) VARCHAR2(5) NOT NULL Training Group

    Prompt Table: TRN_T_GRP_VWESP

    5 TRN_T_LEVEL_ESP Character(1) VARCHAR2(1) NOT NULL Training Level
    B=Basic
    H=Higher

    Default Value: B

    6 TRN_T_CHK_FNSH_ESP Character(1) VARCHAR2(1) NOT NULL Finished
    F=5 - Finished and Reported
    I=2 - Initiated No Reported
    N=1 - Defined / Approved
    R=3 - Initiated and Reported
    Y=4 - Finished No Reported

    Default Value: N

    7 TRN_T_TYP_CMP_ESP Character(1) VARCHAR2(1) NOT NULL Company
    0=Organizing Entity Means
    1=Benefited Company Means

    Default Value: Y

    8 TRN_T_TYP_CNTR_ESP Character(1) VARCHAR2(1) NOT NULL Studies Center

    Y/N Table Edit

    Default Value: N

    9 TRN_T_TYP_ENTI_ESP Character(1) VARCHAR2(1) NOT NULL Organizing Entity

    Y/N Table Edit

    Default Value: N

    10 TRN_T_RSPNSBLE_ESP Character(100) VARCHAR2(100) NOT NULL Responsible
    11 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

    Prompt Table: PERS_SRCH_GBL

    12 TRN_T_CHK_CNTR_ESP Character(1) VARCHAR2(1) NOT NULL Private Contribution
    0=Bonificated Group
    1=Private Contribution

    Default Value: 0

    13 TRN_T_PRI_MBRS_ESP Number(3,0) SMALLINT NOT NULL High Priority Members
    14 TRN_T_STD_SESN_ESP Number(3,0) SMALLINT NOT NULL Students/Session
    15 COMMENTS Long Character CLOB Comment
    16 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

    Prompt Table: TRN_T_VND_ESPVW

    17 TRN_T_VEN_CIF1_ESP Character(10) VARCHAR2(10) NOT NULL Vendor CIF
    18 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

    Prompt Table: TRN_T_FAC_ESPVW

    19 TRN_T_FAC_CIF1_ESP Character(10) VARCHAR2(10) NOT NULL Facility CIF
    20 TRN_T_ST_MRNG1_ESP Time(15) TIMESTAMP Start Time Morning
    21 TRN_T_ET_MRNG1_ESP Time(15) TIMESTAMP End Time Morning
    22 TRN_T_ST_EVNG1_ESP Time(15) TIMESTAMP Start Time Evening
    23 TRN_T_ET_EVNG1_ESP Time(15) TIMESTAMP End Time Evening
    24 TRN_T_TRNG_HR1_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
    25 TRN_T_DAYS1_ESP Character(7) VARCHAR2(7) NOT NULL Days Of Week
    26 MON Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: N

    27 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: N

    28 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: N

    29 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: N

    30 FRI Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: N

    31 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: N

    32 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: N

    33 TRN_T_VENDOR2_ESP Character(6) VARCHAR2(6) NOT NULL Vendor Id

    Prompt Table: TRN_T_VND_ESPVW

    34 TRN_T_VEN_CIF2_ESP Character(9) VARCHAR2(9) NOT NULL Vendor CIF
    35 TRN_T_FACILTY2_ESP Character(6) VARCHAR2(6) NOT NULL Facility Id

    Prompt Table: TRN_T_FAC_ESPVW

    36 TRN_T_FAC_CIF2_ESP Character(9) VARCHAR2(9) NOT NULL Facility CIF
    37 TRN_T_ST_MRNG2_ESP Time(15) TIMESTAMP Start Time Morning
    38 TRN_T_ET_MRNG2_ESP Time(15) TIMESTAMP End Time Morning
    39 TRN_T_ST_EVNG2_ESP Time(15) TIMESTAMP Start Time Evening
    40 TRN_T_ET_EVNG2_ESP Time(15) TIMESTAMP End Time Evening
    41 TRN_T_TRNG_HR2_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
    42 TRN_T_DAYS2_ESP Character(7) VARCHAR2(7) NOT NULL Days Of Week
    43 TRN_T_MON1_ESP Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: N

    44 TRN_T_TUE1_ESP Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: N

    45 TRN_T_WED1_ESP Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: N

    46 TRN_T_THURS1_ESP Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: N

    47 TRN_T_FRI1_ESP Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: N

    48 TRN_T_SAT1_ESP Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: N

    49 TRN_T_SUN1_ESP Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: N

    50 TRN_T_VENDOR3_ESP Character(6) VARCHAR2(6) NOT NULL Remote Assistance

    Prompt Table: TRN_T_VND_ESPVW

    51 TRN_T_VEN_CIF3_ESP Character(9) VARCHAR2(9) NOT NULL Vendor CIF
    52 TRN_T_FACILTY3_ESP Character(6) VARCHAR2(6) NOT NULL Remote Assistance

    Prompt Table: TRN_T_FAC_ESPVW

    53 TRN_T_FAC_CIF3_ESP Character(9) VARCHAR2(9) NOT NULL Facility CIF
    54 TRN_T_ST_MRNG3_ESP Time(15) TIMESTAMP Start Time Morning
    55 TRN_T_ET_MRNG3_ESP Time(15) TIMESTAMP End Time Morning
    56 TRN_T_ST_EVNG3_ESP Time(15) TIMESTAMP Start Time Evening
    57 TRN_T_ET_EVNG3_ESP Time(15) TIMESTAMP End Time Evening
    58 TRN_T_TRNG_HR3_ESP Number(7,2) DECIMAL(6,2) NOT NULL Training Hours
    59 TRN_T_DAYS3_ESP Character(7) VARCHAR2(7) NOT NULL Days Of Week
    60 TRN_T_MON2_ESP Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: N

    61 TRN_T_TUE2_ESP Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: N

    62 TRN_T_WED2_ESP Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: N

    63 TRN_T_THURS2_ESP Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: N

    64 TRN_T_FRI2_ESP Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: N

    65 TRN_T_SAT2_ESP Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: N

    66 TRN_T_SUN2_ESP Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: N

    67 TRN_T_BGN_CRS_ESP Date(10) DATE Start Date
    68 TRN_T_END_CRS_ESP Date(10) DATE End Date
    69 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

    Prompt Table: TRN_T_EE_PHN_VW

    70 TRN_T_SCHEDULE_ESP Character(1) VARCHAR2(1) NOT NULL Session Schedule
    N=Non Working Hours
    T=In Working Hours

    Default Value: N

    71 TRN_T_PCT_ESP Number(6,2) DECIMAL(5,2) NOT NULL Percentage
    72 TRN_T_HOURS_ESP Number(7,2) DECIMAL(6,2) NOT NULL Number Hours
    73 TRN_T_FACILTY4_ESP Character(6) VARCHAR2(6) NOT NULL eLearning Assistance

    Prompt Table: TRN_T_FAC_ESPVW

    74 TRN_T_VENDOR4_ESP Character(6) VARCHAR2(6) NOT NULL eLearning Assistance

    Prompt Table: TRN_T_VND_ESPVW

    75 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year