HCTS_CFG_TBL_FL

(SQL Table)
 Index Back

EmployeeSnapshot Configuration

Employee Snapshot Configuration - Main Record

  • Related Language Record: HCTS_CFG_LNG_FL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HCTS_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

    Prompt Table: HCTS_RVW_PRF_VW

    2 HCTS_PERF_RANGE Number(4,0) SMALLINT NOT NULL Performance Range
    3 HCTS_COMP_RANGE Number(4,0) SMALLINT NOT NULL Competency Range
    4 HCTS_COMPARE Character(1) VARCHAR2(1) NOT NULL Compare Person w/Job Profile
    N=No
    Y=Yes

    Default Value: N

    5 HCTS_ALERT_DAYS Number(3,0) SMALLINT NOT NULL Days for Warning Alert
    6 HCTS_PROJ_RANGE Number(4,0) SMALLINT NOT NULL Project Range
    7 EP_REVIEW_TYPE Character(8) VARCHAR2(8) NOT NULL Review type

    Prompt Table: HCTS_RVW_PRF_VW

    8 HCTS_LOSSRSK_LABEL Character(15) VARCHAR2(15) NOT NULL Risk Axis Label
    9 HCTS_IMPACT_LABEL Character(15) VARCHAR2(15) NOT NULL Impact Axis Label
    10 HCTS_PERF_AXIS Character(1) VARCHAR2(1) NOT NULL Performance Rating Axis
    1=1
    2=2
    3=3
    4=4
    5=5

    Default Value: 3

    11 HCTS_PERF_LABEL Character(15) VARCHAR2(15) NOT NULL Performance Axis Label
    12 HCTS_POTENTL_AXIS Character(1) VARCHAR2(1) NOT NULL Potential Rating Axis
    1=1
    2=2
    3=3
    4=4
    5=5

    Default Value: 3

    13 HCTS_POTENTL_LABEL Character(15) VARCHAR2(15) NOT NULL Potential Axis Label
    14 HCTS_HIDE_RTBX1 Character(1) VARCHAR2(1) NOT NULL Display Rating Box Chart
    N=No
    Y=Yes

    Default Value: N

    15 HCTS_HIDE_RTBX2 Character(1) VARCHAR2(1) NOT NULL Display Rating Box Chart
    N=No
    Y=Yes

    Default Value: N

    16 HCTS_SP_DRAFT Character(1) VARCHAR2(1) NOT NULL Draft
    N=No
    Y=Yes

    Default Value: N

    17 HCTS_SP_OFFICIAL Character(1) VARCHAR2(1) NOT NULL Official
    N=No
    Y=Yes

    Default Value: N

    18 HCTS_DVLP_RANGE Number(4,0) SMALLINT NOT NULL Development Range