HRS_TRAIN_HST

(SQL Table)
 Index Back

App Training History

Use APP_TRAINING to record data about training courses, both internal and external, taken by a student that is an applicant. You can create multiple APP_TRAINING records for a student.

  • Parent record: HRS_APPLICANT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    4 COURSE_START_DT Date(10) DATE Course Start Date
    5 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL

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

    Prompt Table: CRSE_ALL_SSN_VW

    7 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    8 GVT_TREQ_DATA_REQ Character(1) VARCHAR2(1) NOT NULL Training Request Required

    Y/N Table Edit

    Default Value: N

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

    Default Value: NEW

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

    Default Value: %date

    12 GVT_TRNG_OBJS Character(254) VARCHAR2(254) NOT NULL Training Objectives
    13 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
    14 GVT_DUTY_HRS Number(3,0) SMALLINT NOT NULL Duty Hours
    15 GVT_NONDUTYHRS Number(3,0) SMALLINT NOT NULL Non Duty Hours
    16 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
    17 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
    18 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
    19 GVT_TC_SPECIALINT Character(1) VARCHAR2(1) NOT NULL Training Code Special Interest
    0=No Special Program
    1=Executive Development
    2=Supervision
    20 GVT_PURCHASEORDER Character(25) VARCHAR2(25) NOT NULL Document/Purchase Order/Req No
    21 GVT_STATION_SYMBOL Character(10) VARCHAR2(10) NOT NULL Station Symbol
    22 GVT_BILLING_INSTR Character(254) VARCHAR2(254) NOT NULL Billing Instructions + Invoice
    23 GVT_NONGOVTTRNDAYS Number(3,0) SMALLINT NOT NULL Non Government Training Days
    24 GVT_DC_APPRFUND Character(90) VARCHAR2(90) NOT NULL Direct Cost Appropriation/Fund
    25 GVT_IC_APPRFUND Character(90) VARCHAR2(90) NOT NULL Indirect Cost Appropriatn/Fund
    26 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    27 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    28 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    29 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    30 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    31 CITY Character(30) VARCHAR2(30) NOT NULL City
    32 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    33 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    34 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    35 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    36 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    37 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    38 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    39 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    40 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    41 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    42 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

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

    Prompt Table: COUNTRY_TBL

    44 ADDRESS1_OTHER Character(55) VARCHAR2(55) NOT NULL Address 1 Other
    45 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
    46 ADDRESS3_OTHER Character(55) VARCHAR2(55) NOT NULL Address 3 Other
    47 ADDRESS4_OTHER Character(55) VARCHAR2(55) NOT NULL Address 4 Other
    48 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
    49 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
    50 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other

    Prompt Table: STATE_OTH

    51 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    52 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    53 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    54 HOUSE_TYPE_OTHER Character(2) VARCHAR2(2) NOT NULL House Type Other
    AB=House Boat Reference
    WW=House Trailer Reference
    55 ADDR_FIELD1_OTHER Character(2) VARCHAR2(2) NOT NULL Address Field 1 Other
    56 ADDR_FIELD2_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 2 Other
    57 ADDR_FIELD3_OTHER Character(4) VARCHAR2(4) NOT NULL Address Field 3 Other
    58 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other

    Y/N Table Edit

    59 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    60 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

    Prompt Table: TRN_VENDOR_TBL

    61 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    62 COURSE_END_DT Date(10) DATE Course End Date
    63 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal

    Default Value: E

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

    Prompt Table: SCHOOL_TBL

    65 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    66 DT_NEEDED Date(10) DATE Date Needed
    67 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

    68 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

    69 WAIT_DT Date(10) DATE Waitlist Entry Date
    70 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
    71 COURSE_GRADE Character(3) VARCHAR2(3) NOT NULL Grade
    A=A
    B=B
    C=C
    D=D
    F=F
    FL=Fail
    P=Pass
    72 HRS_REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL The Fusion Publisher Report Definition ID used by Recruiting
    73 HRS_REPORT_TMPL_ID Character(30) VARCHAR2(30) NOT NULL The Fusion publisher Report template ID used by RS.
    74 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    75 PREREQ_MET Character(1) VARCHAR2(1) NOT NULL Prerequisites Met

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: %RECNAME_EDIT

    78 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    79 TRAINING_LEAVE_FRA Character(1) VARCHAR2(1) NOT NULL Training Leave

    Y/N Table Edit

    Default Value: N

    80 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
    81 PART_TIME_CRSE_FRA Character(1) VARCHAR2(1) NOT NULL Part Time Course

    Y/N Table Edit

    Default Value: N

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

    Default Value: H

    Prompt Table: DT_COST_UNIT_VW

    83 TIME_SPENT_FRA Number(6,1) DECIMAL(5,1) NOT NULL Time spent at training
    84 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration
    85 TRN_IMPUTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Chargeable

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    87 TRN_HOURS_FRA Number(3,0) SMALLINT NOT NULL Training Hours
    88 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    89 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    90 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    91 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    92 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id