TRAINING

(SQL Table)
 Index Back

EE Training History

Use TRAINING to record data about training courses, both internal and external, taken by a student. A student can be an employee, an applicant, or a non-employee. You can create multiple TRAINING records for a student.

  • Parent Record Of STUDY_BANK_AUS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    2 COURSE_START_DT Date(10) DATE Course Start Date
    3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL_VW

    4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr

    Prompt Table: CRSE_ATV_SSN_VW

    5 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    6 COURSE_END_DT Date(10) DATE Course End Date
    7 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal

    Default Value: E

    8 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

    Prompt Table: SCHOOL_TBL_VW2

    9 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    10 DT_NEEDED Date(10) DATE Date Needed
    11 ATTENDANCE Character(1) VARCHAR2(1) NOT NULL Enrollment/Attendance
    A=Currently Attending
    C=Completed
    D=Dropped
    E=Enrolled
    I=Incomplete
    L=Cancelled
    N=No Show
    O=Training Request Approved
    P=Need for Career Plan
    R=Request
    S=Session Waitlist
    T=Need for Training Program
    U=Training Request Authorized
    W=Course Waitlist
    X=Cancel Request for Training

    Default Value: W

    12 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    13 WAIT_DT Date(10) DATE Waitlist Entry Date
    14 TRAINING_REASON Character(2) VARCHAR2(2) NOT NULL Training Reason
    CM=Compliance
    DV=Development
    EN=Enrichment
    JR=Job Requirement
    LC=License Renewal
    MD=Management Discretion
    RQ=Requalification
    SE=Skill Enhancement
    15 COURSE_GRADE Character(3) VARCHAR2(3) NOT NULL Grade
    A=A
    B=B
    C=C
    D=D
    F=F
    FL=Fail
    P=Pass
    16 LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter code

    Prompt Table: TRN_STD_LTR_VW

    17 LETTER_SENT_DT Date(10) DATE Date Letter Sent
    18 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    19 PREREQ_MET Character(1) VARCHAR2(1) NOT NULL Prerequisites Met

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: BUS_UNIT_TBL_HR

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

    Prompt Table: DEPT_TBL

    22 DEMAND_ID Character(10) VARCHAR2(10) NOT NULL Demand ID

    Prompt Table: %RECNAME_EDIT

    23 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    24 DIPLOMA_ESP Character(1) VARCHAR2(1) NOT NULL Accredinting diploma flag

    Y/N Table Edit

    Default Value: N

    25 TRAINING_LEAVE_FRA Character(1) VARCHAR2(1) NOT NULL Training Leave

    Y/N Table Edit

    Default Value: N

    26 TRN_PLN_CATEGORY Character(1) VARCHAR2(1) NOT NULL Feild for Training Plan Category
    0=Not Specified
    1=Adaptation to Job Changement
    2=Job Preservation
    3=Skill Development

    Default Value: 0

    27 PART_TIME_CRSE_FRA Character(1) VARCHAR2(1) NOT NULL Part Time Course

    Y/N Table Edit

    Default Value: N

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

    Default Value: H

    Prompt Table: DT_COST_UNIT_VW

    29 TIME_SPENT_FRA Number(6,1) DECIMAL(5,1) NOT NULL Time spent at training
    30 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration
    31 TRN_IMPUTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Chargeable

    Y/N Table Edit

    Default Value: N

    32 TRN_DIF_FRA_FLG Character(1) VARCHAR2(1) NOT NULL Field for Training DIF

    Y/N Table Edit

    Default Value: N

    33 TRN_HOURS_FRA Number(3,0) SMALLINT NOT NULL Training Hours
    34 TRN_PROF_FLG_FRA Character(1) VARCHAR2(1) NOT NULL Professionalisation Period Flag

    Y/N Table Edit

    Default Value: N

    35 TRN_OUTWRK_FLG_FRA Character(1) VARCHAR2(1) NOT NULL Out of Working Schedule Flag

    Y/N Table Edit

    Default Value: N

    36 TRN_EE_DURATION_SW Character(1) VARCHAR2(1) NOT NULL Radio Button for Training Employee Duration
    0=Training Duration from Session
    1=Specify Student Duration

    Default Value: 0

    37 GVT_TREQ_DATA_REQ Character(1) VARCHAR2(1) NOT NULL Training Request Required

    Y/N Table Edit

    Default Value: N

    38 GVT_TRNG_REQNUM Character(20) VARCHAR2(20) NOT NULL Training Request Number

    Default Value: NEW

    39 GVT_TREQ_REQ_SEQ Number(4,0) SMALLINT NOT NULL Trn Request Number Sequence
    40 GVT_TRNG_REQ_DATE Date(10) DATE Training Request Date

    Default Value: %date

    41 GVT_TRNG_OBJS Character(254) VARCHAR2(254) NOT NULL Training Objectives
    42 GVT_TRN_LOC_IND Character(1) VARCHAR2(1) NOT NULL Training Location Indicator
    C=Course Session Table Address
    O=Other Address
    V=Same asTraining Vendor
    43 GVT_DUTY_HRS Number(3,0) SMALLINT NOT NULL Duty Hours
    44 GVT_NONDUTYHRS Number(3,0) SMALLINT NOT NULL Non Duty Hours
    45 GVT_TC_PURPOSE Character(1) VARCHAR2(1) NOT NULL Training Code Purpose
    1=Mission or program Change
    2=New Technology
    3=New work assignment
    4=Improve Present Performance
    5=Meet Future Staffing Needs
    6=Develop unavailable skill
    7=Trade or Craft Apprenticeship
    8=Orientation
    9=Basic Adult Education
    46 GVT_TC_TYPE Character(1) VARCHAR2(1) NOT NULL Training Code Type
    1=Executive & Management
    2=Supervisory
    3=Lgl,Medical,Scientific,Engrng
    4=Administration and Analysis
    5=Specialty and Technical
    6=Clerical
    7=Trade or craft
    8=Orientation
    47 GVT_TC_SOURCE Character(1) VARCHAR2(1) NOT NULL Training Code Source
    1=Govt - Agency
    2=Govt - Interagency
    3=Non-Gvt Design for Agency
    4=Non-Gvt Off-Shelf
    5=State or Local Gvt
    48 GVT_TC_SPECIALINT Character(1) VARCHAR2(1) NOT NULL Training Code Special Interest
    0=No Special Program
    1=Executive Development
    2=Supervision
    49 GVT_PURCHASEORDER Character(25) VARCHAR2(25) NOT NULL Document/Purchase Order/Req No
    50 GVT_STATION_SYMBOL Character(10) VARCHAR2(10) NOT NULL Station Symbol
    51 GVT_BILLING_INSTR Character(254) VARCHAR2(254) NOT NULL Billing Instructions + Invoice
    52 GVT_NONGOVTTRNDAYS Number(3,0) SMALLINT NOT NULL Non Government Training Days
    53 GVT_DC_APPRFUND Character(90) VARCHAR2(90) NOT NULL Direct Cost Appropriation/Fund
    54 GVT_IC_APPRFUND Character(90) VARCHAR2(90) NOT NULL Indirect Cost Appropriatn/Fund
    55 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    56 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    57 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    58 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    59 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    60 CITY Character(30) VARCHAR2(30) NOT NULL City
    61 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    62 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    63 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    64 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    65 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    66 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    67 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    68 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    69 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    70 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    71 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    72 COUNTRY_OTHER Character(3) VARCHAR2(3) NOT NULL Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT

    Prompt Table: COUNTRY_TBL

    73 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    74 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    75 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    76 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    77 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    78 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    79 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    80 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    81 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    82 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    83 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    84 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    85 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    86 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    87 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    88 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    89 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

    Prompt Table: TRN_VENDOR_TBL

    90 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    91 ATTENDANCE_BK Character(1) VARCHAR2(1) NOT NULL Enrollment/Attendance
    A=Currently Attending
    C=Completed
    D=Dropped
    E=Enrolled
    I=Incomplete
    L=Cancelled
    N=No Show
    P=Need for Career Plan
    R=Request
    S=Session Waitlist
    T=Need for Training Program
    U=Training Request Authorized
    W=Course Waitlist
    X=Cancel Request for Training
    92 LETTER_CD_BK Character(3) VARCHAR2(3) NOT NULL Letter Code
    93 LETTER_PRINT_DT_BK Date(10) DATE Date Letter Printed
    94 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Default Value: 0