HRS_APP_TRAIN

(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 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 COURSE_START_DT Date(10) DATE NOT NULL Course Start Date
    3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL

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

    Prompt Table: CRSE_ALL_SSN_VW

    5 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
    6 GVT_TREQ_DATA_REQ Character(1) VARCHAR2(1) NOT NULL Training Request Required

    Y/N Table Edit

    Default Value: N

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

    Default Value: NEW

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

    Default Value: %date

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

    Prompt Table: SCC_CNT_ADFMTVW

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

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

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_OTH

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

    Y/N Table Edit

    57 GEO_CODE_OTHER Character(11) VARCHAR2(11) NOT NULL Geo Code Other
    58 VENDOR Character(6) VARCHAR2(6) NOT NULL Vendor ID

    Prompt Table: TRN_VENDOR_TBL

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

    Default Value: E

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

    Prompt Table: SCHOOL_TBL

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

    66 STATUS_DT Date(10) DATE Status Date

    Default Value: %date

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: %RECNAME_EDIT

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: H

    Prompt Table: DT_COST_UNIT_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

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

    Prompt Table: BUS_UNIT_TBL_HR

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