RUN_CNTL_HR

(SQL Table)
 Index Back

HR Run Control

RUN_CNTL_HR contains fields that are used as input parameters for the various HR Reports. Input data is retrieved from this record when a report is requested from the Process Scheduler.

  • Parent Record Of BP_RNCTL_CMP107 GPFR_ES_PAYGRP HCR_OC_ASG_TMP RUNCTL_CMP007 RUN_CNTL_CMP015 RUN_CNTL_CMP016 RUN_CNTL_CMP107 RUN_CNTL_PER501

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 TRN_CHARGEABLE_ORG Character(1) VARCHAR2(1) NOT NULL Chargeable Organization
    D=From Enrollment Department
    J=From Employee Company Code
    4 FROMDATE Date(10) DATE From Date
    5 THRUDATE Date(10) DATE End Date
    6 ASOFDATE Date(10) DATE As of Date
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    9 DECL_YR_2483_FRA Number(4,0) SMALLINT NOT NULL French Report 2483 : Declaring Year

    Prompt Table: TRN_2483_PARM

    10 SERVICE_YEARS Number(2,0) SMALLINT NOT NULL Years of Service
    11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    12 POS_ACTIVE_OPTION Character(1) VARCHAR2(1) NOT NULL Pos Active,Inactive,Both Optn
    1=Active
    2=Inactive
    3=Both Active and Inactive
    13 POS_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active Positions
    A=Position Active
    14 POS_INACTIVE Character(1) VARCHAR2(1) NOT NULL Inactive Positions
    I=Position Inactive
    15 POS_REPORT_LEVEL Number(2,0) SMALLINT NOT NULL Pos Hierarchy Report Level
    16 POS_VACANT_REQUEST Character(1) VARCHAR2(1) NOT NULL Request for Vacant Pos Report
    1=Run Vacant Budgeted Positn Rpt
    2=Create Requistn for Vacant Pos
    17 POS_EXCEPT_OVRRIDE Character(1) VARCHAR2(1) NOT NULL Position Exception Override
    E=Exception
    O=Override
    18 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number
    19 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

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

    Prompt Table: DEPARTMENT_SRCH

    21 REPORT_CHOICE Character(1) VARCHAR2(1) NOT NULL Output Report Choice
    1=Applicants
    2=Current Employees
    3=Both Applicants and Employees
    22 POPULATION Character(1) VARCHAR2(1) NOT NULL Search Population-Skill Match
    1=All
    2=Internal Applicants
    3=External Applicants
    4=Candidates for Specific Positn
    23 EE_REPORT_YEAR Number(4,0) SMALLINT NOT NULL Empl Equity Reporting Year
    24 BUDGET_START_DT Date(10) DATE Budget Start Date

    Prompt Table: RUN_BUDGET1_VW

    25 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

    26 INCR_START_DT Date(10) DATE Start Date for Step Increments
    27 INCR_END_DT Date(10) DATE End Date for Step Increments
    28 JOB_EFFDT Date(10) DATE Job Effective Date
    29 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    30 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    31 PERCENTCHG Number(8,2) DECIMAL(7,2) NOT NULL Calculation Percent
    32 AMOUNTCHG Number(8,2) DECIMAL(7,2) NOT NULL Amount of Salary Change
    33 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERALL_SEC_SRCH

    34 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

    Prompt Table: INCIDENT_DATA

    35 CAN_OEE_AREACD Character(2) VARCHAR2(2) NOT NULL CEC Management Area
    01=Toronto Management Area
    02=Hamilton Management Area
    03=Niagra Management Area
    04=Brant Haldimand, Norfolk Area
    05=Windsor Management Area
    06=London Management Area
    07=Kitchener Management Area
    08=Mississauga Management Area
    09=Brampton Management Area
    10=York Management Area
    11=Georgian Bay Management Area
    12=Kenora Management Area
    13=Timmins Management Area
    14=Slt.St.Marie Management Area
    15=Sudbury Management Area
    16=North Bay Management Area
    17=Pembroke Management Area
    18=Ottawa Management Area
    19=Cornwall Management Area
    20=Kingston Management Area
    21=Belleville Management Area
    22=Peterborough Management Area
    23=Oshawa Management Area

    Default Value: 01

    36 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL

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

    Prompt Table: CRSE_ALL_SSN_VW

    38 COURSE_START_DT Date(10) DATE Course Start Date
    39 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

    Prompt Table: TRN_FACIL_TBL

    40 AD_SALADMIN_PLN Character(1) VARCHAR2(1) NOT NULL Audit Salary Admin Plan

    Y/N Table Edit

    41 AD_GRADE Character(1) VARCHAR2(1) NOT NULL Audit Grade
    N=Report Only
    Y=Report & Process Increases
    42 AD_GRADE_ENTRY_DT Character(1) VARCHAR2(1) NOT NULL Audit Grade Entry Date

    Y/N Table Edit

    43 AD_STEP Character(1) VARCHAR2(1) NOT NULL Audit Step

    Y/N Table Edit

    44 AD_STEP_ENTRY_DT Character(1) VARCHAR2(1) NOT NULL Audit Step Entry Date

    Y/N Table Edit

    45 AD_COMPRATE Character(1) VARCHAR2(1) NOT NULL Audit Comprate

    Y/N Table Edit

    46 AD_HOURLYRT Character(1) VARCHAR2(1) NOT NULL Audit Hourly Rate

    Y/N Table Edit

    47 AD_MONTHLYRT Character(1) VARCHAR2(1) NOT NULL Audit Monthly Rate

    Y/N Table Edit

    48 AD_ANNUALRT Character(1) VARCHAR2(1) NOT NULL Audit Annual Rate

    Y/N Table Edit

    49 AD_CHANGEAMT Character(1) VARCHAR2(1) NOT NULL Audit Change Amount

    Y/N Table Edit

    50 AD_CHANGEPCT Character(1) VARCHAR2(1) NOT NULL Audit Change Percentage

    Y/N Table Edit

    51 EEO_REPORT_TYPE Character(4) VARCHAR2(4) NOT NULL EEO Report Run Type
    GOVT=Govt. Report Run
    INFO=Informational Report Run
    52 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost
    53 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

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

    Default Value: STUD/D

    Prompt Table: PR_COST_UNIT_VW

    55 APPLY_SALARY_COST Character(1) VARCHAR2(1) NOT NULL Employee Training Cost
    D=Defaulting from Jobcodes
    E=Apply on Employees
    G=Load from Global Payroll
    J=Apply on Jobcodes

    Default Value: J

    56 BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Budget Period

    Prompt Table: BUDGET_PERIOD

    57 DEMAND_PRIORITY Character(1) VARCHAR2(1) NOT NULL Demand Priority
    1=High
    2=Medium
    3=Low

    Default Value: 2

    58 EFFDT Date(10) DATE Effective Date
    59 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Base Currency
    60 ATTENDANCE_IN Character(23) VARCHAR2(23) NOT NULL Attendance In
    61 SCENARIO Character(10) VARCHAR2(10) NOT NULL Scenario

    Prompt Table: TRN_GBL_SCE_VW

    62 NEW_SCENARIO Character(10) VARCHAR2(10) NOT NULL New Scenario
    63 ACTIVE_NEW Character(1) VARCHAR2(1) NOT NULL Active New Scenario

    Y/N Table Edit

    Default Value: N

    64 SCENARIO_TYPE Character(1) VARCHAR2(1) NOT NULL Scenario Type
    A=Active Scenario
    G=Global Scenario
    65 APPROVED_FACTOR Number(6,2) DECIMAL(5,2) NOT NULL Increase Approved by Factor
    66 APPROVE_PRIORITY Character(1) VARCHAR2(1) NOT NULL Higher than Priority
    1=High Priority
    2=Medium Priority
    3=Low Priority

    Default Value: 2

    67 UNAPPROVE_PRIORITY Character(1) VARCHAR2(1) NOT NULL Less than Priority
    1=High Priority
    2=Medium Priority
    3=Low Priority

    Default Value: 2

    68 IND_DMND_CNTRL_SW Character(1) VARCHAR2(1) NOT NULL Individual Demand Control
    A=Approve
    D=Unapprove
    N=All Demands

    Default Value: N

    69 YEAR_NBR Number(1,0) SMALLINT NOT NULL Years Number
    70 GROUP_SHEET_ID_FRA Character(2) VARCHAR2(2) NOT NULL Indicator Group

    Prompt Table: GROUP_SHEET_FRA

    71 INDICATR_SHEET_FRA Character(5) VARCHAR2(5) NOT NULL Indicator

    Prompt Table: INDIC_SHEET_FRA

    72 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_TBL

    73 FROM_CLAUSE Character(253) VARCHAR2(253) NOT NULL Scenario From Clause
    74 WHERE_CLAUSE Long Character(500) VARCHAR2(500) Where Clause
    75 WHERE_CLS_ER Long Character(4096) CLOB Where Clause for Rules and Hot Jobs
    76 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUS_UNIT_TBL_HR

    77 BUDGET_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUDGET_BUS_UNIT

    78 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    79 FZN_BUDGET_BUSUNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: TRN_FZN_BGT_BU

    80 TRGT_BUDGET_PERIOD Character(10) VARCHAR2(10) NOT NULL Target Budget Period

    Prompt Table: TRN_NFZNBDGT_VW

    81 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    82 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    83 NO_REVIEW Character(1) VARCHAR2(1) NOT NULL Review Required
    84 GROUP_SHEET_CD_FRA Character(1) VARCHAR2(1) NOT NULL Indicator Group

    Prompt Table: GROUP_SHEET_FRA

    85 INDIC_SHEET_CD_FRA Character(5) VARCHAR2(5) NOT NULL Indicator

    Prompt Table: INDIC_SHEET_FRA

    86 CREATION_DT Date(10) DATE Creation Date

    Default Value: %DATE

    87 PURGE_BASED_ON Character(1) VARCHAR2(1) NOT NULL Purge Based On
    A=Application Date
    P=Application Purge Date

    Default Value: P

    88 PURGE_PRCS_OPTION Character(1) VARCHAR2(1) NOT NULL Purge Process Option
    1=Print and Process
    2=Process Only
    3=Print Only

    Default Value: 3

    89 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

    Prompt Table: COMPRT_GRP_TBL

    90 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: BASE_RATECD_VW

    91 WC_COUNCIL_ID Character(9) VARCHAR2(9) NOT NULL Works Council ID

    Prompt Table: WC_COUNCIL_TBL

    92 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    93 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
    94 COMP_CHG_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    95 COMP_CHG_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    96 COMP_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    97 AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application
    98 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator

    Y/N Table Edit

    Default Value: N

    99 DEC2483_YEAR Date(10) DATE DEC2483 Year
    100 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    101 SINGLE_CHECK Character(1) VARCHAR2(1) NOT NULL Multiple State Employer

    Y/N Table Edit

    Default Value: N

    102 STATE_NUMBER Character(2) VARCHAR2(2) NOT NULL State Number
    103 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_SEC_VW

    104 GB_GROUP_ID2 Character(15) VARCHAR2(15) NOT NULL Group ID

    Prompt Table: GB_GROUP_ID_DW

    105 GB_EFFDT Date(10) DATE Group As Of Date

    Default Value: %date

    106 GB_REFINE_DATE Date(10) DATE Refinement Date
    107 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_REGION_TBL

    108 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID

    Prompt Table: BUDGET_COMP1_VW

    109 MULT_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL Multiple Company Field

    Y/N Table Edit

    Default Value: N

    110 REVIEW_TYPE Character(1) VARCHAR2(1) NOT NULL Review Type
    A=Self Assesssment
    B=Both
    E=Employee Feedback
    I=Initial Rating
    M=Interim Rating
    O=Official Rating
    P=Performance
    R=Adjustment Result
    S=Salary
    111 PROCESS_BY Character(1) VARCHAR2(1) NOT NULL Used by the RUNCTL_SENPAY run control panel.
    A=All
    G=Group ID
    J=Jobcode
    L=Sal Admin Plan
    P=Paygroup
    R=Rate Code
    S=Sal Plan/Grade

    Default Value: R

    112 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID

    Prompt Table: TRN_INSTRCT_VW

    113 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number
    114 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal
    115 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
    CWR=Contingent Worker
    EMP=Employee
    POI=Person of Interest
    116 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

    Prompt Table: OPRDEFN_SCRTY4

    117 DEGREE_SW Character(1) VARCHAR2(1) NOT NULL Degree Detail
    N=No
    Y=Yes
    118 LICENSE_CERTIF_SW Character(1) VARCHAR2(1) NOT NULL License/Certification Detail
    N=No
    Y=Yes
    119 TRAINING_TYPE Character(1) VARCHAR2(1) NOT NULL Training Type
    A=Administer Training
    B=Budget Training

    Default Value: A

    120 TYPE_SHEET_CD_FRA Character(2) VARCHAR2(2) NOT NULL Used to regroup Employee Survey groups of indicators, based on legal requirement.
    CT=Trade & Services Company
    ET=Trade & Services Establishment
    121 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD1

    122 EMP_LIST_CRITERIA Character(1) VARCHAR2(1) NOT NULL Employee Listing Criteria
    D=Department
    I=Employee Id
    N=Employee Name
    123 DETYA_REP_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used to identify the type of reporting being generated for DETYA purposes.
    C=Casual Staff
    S=Permanent Employee

    Default Value: S

    124 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: LIC_CERTIF_VW

    125 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    126 FP_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee or Spouse ID

    Prompt Table: %RECNAME_EDIT

    127 FP_CORPS_CD Character(6) VARCHAR2(6) NOT NULL Corps

    Prompt Table: FPMCORPS_TBL

    128 FP_STATUSEE_CD Character(1) VARCHAR2(1) NOT NULL Employee status
    129 FP_HYP_NBR Number(3,0) SMALLINT NOT NULL Assumption Nbr
    130 FP_YES_NO Character(1) VARCHAR2(1) NOT NULL YES/NO Fields

    Y/N Table Edit

    131 FP_CHG_SAL Character(1) VARCHAR2(1) NOT NULL Forced Salary
    132 FP_ORIG Character(1) VARCHAR2(1) NOT NULL Row Origin
    A=Order Abrogation
    C=Collective Orders
    I=Individual Orders (Single)
    J=Individual Orders (Mass)
    R=Retroactivity Abrogation
    133 FP_EDT_TMP Character(1) VARCHAR2(1) NOT NULL Provisional Editing
    134 FP_EDT_FNL Character(1) VARCHAR2(1) NOT NULL Final Editing
    135 FP_COLDEC_NBR Character(12) VARCHAR2(12) NOT NULL Collective Order Nbr
    136 FP_REFCOL_PS Number(8,0) INTEGER NOT NULL PSoft Ref Collective Order
    137 FP_NOTIF_REF Character(8) VARCHAR2(8) NOT NULL Order reference
    138 FP_CONVERSION_ID Character(20) VARCHAR2(20) NOT NULL Reclassification ID

    Prompt Table: FPMCONVTABL0_TB

    139 FP_ADM_APPL_DT Date(10) DATE Application Admin Date
    140 FP_CONV_EFFDT Date(10) DATE Conversion Effective Date

    Prompt Table: FPMCONVTABL_VW1

    141 FP_FROMDATE_CHECK Date(10) DATE Checking Start Date
    142 FP_RATING_PRS Number(3,0) SMALLINT NOT NULL Rating Attendance
    143 FP_THRUDATE Date(10) DATE Starting Date

    Prompt Table: FPMPROMTABL_VW

    144 FP_RANK_START Character(6) VARCHAR2(6) NOT NULL Grade of Origin

    Prompt Table: FPMPROMTAB02_VW

    145 FP_SETID_RANK Character(5) VARCHAR2(5) NOT NULL Set ID

    Prompt Table: FPMPROMTAB01_VW

    146 FP_CA_CATG_ID Character(6) VARCHAR2(6) NOT NULL CAE Category

    Prompt Table: FPM_CA_CTG_TBL

    147 FP_STFBDG_LVL1 Character(2) VARCHAR2(2) NOT NULL Section
    EM=Labor
    LG=Housing
    S1=Sector 1
    S2=Sector 2
    SL=Solidarity
    TO=Tourism
    TR=Transportation
    148 FP_FINANC_LAW_ID Character(12) VARCHAR2(12) NOT NULL Finance Act

    Prompt Table: FPM_CA_FINLAW

    149 UPD_FUTURE_ROW_SW Character(1) VARCHAR2(1) NOT NULL Update Future Rows
    N=No
    Y=Yes

    Y/N Table Edit

    150 CREATE_GROUP Character(1) VARCHAR2(1) NOT NULL Populate Group

    Y/N Table Edit

    151 APS_REP_TYPE_AUS Character(1) VARCHAR2(1) NOT NULL This field is required to identify the type of APS Report being generated.
    C=Change Extract
    S=Snapshot Report

    Default Value: S

    152 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    153 CMP_DONT_ABSORB Character(1) VARCHAR2(1) NOT NULL Don't Absorb Changes
    N=No
    Y=Yes

    Y/N Table Edit

    154 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
    N=No
    Y=Yes

    Y/N Table Edit

    155 SP_PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
    156 PRCS_MODE_FLG Character(1) VARCHAR2(1) NOT NULL Update Process updates or adds values according to this flag.
    I=Add new effective date
    U=Correction on current Info.

    Default Value: I

    157 USER_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

    Prompt Table: PSOPRDEFN_SRCH

    158 LOCK_FLAG Character(1) VARCHAR2(1) NOT NULL Create Users as locked

    Y/N Table Edit

    159 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    160 FISCAL_YR_FRA Number(4,0) SMALLINT NOT NULL This field is used for initializing profit sharing dates
    161 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
    162 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP

    163 PRD_BGN_DT Date(10) DATE Period Begin Date
    164 PRD_END_DT Date(10) DATE Pay Period End Date
    165 TRN_FTGROSS_WA_FLD Character(18) VARCHAR2(18) NOT NULL French Report 2483 : Training Gross WA Field

    Default Value: TRN_FT_GROSS_AMT

    Prompt Table: TRN2483_WAFLDVW

    166 TRN_GROSS_WA_FLD Character(18) VARCHAR2(18) NOT NULL Gross Salary WA Field

    Default Value: GROSS_AMT

    Prompt Table: TRN2483_WAFLDVW

    167 TRN_PAID_HR_WA_FLD Character(18) VARCHAR2(18) NOT NULL Paid Hours WA Field

    Default Value: PAID_HOURS

    Prompt Table: TRN2483_WAFLDVW

    168 TRN_DATE_SELECTION Character(1) VARCHAR2(1) NOT NULL French Report 2483 : Select by
    E=Period End Date
    P=Payment Date
    169 TRN_EXT_EXPNS_TBL Character(15) VARCHAR2(15) NOT NULL French Report 2483 : External Expense record

    Prompt Table: RECDEFN_VW

    170 TRN_PLN_CAT_SW Character(1) VARCHAR2(1) NOT NULL Flag for Training Plan Category
    0=Training Plan Category
    1=Scenario

    Default Value: 1

    171 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

    172 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

    Default Value: 1

    173 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
    174 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HR_RFWSTATE_VW