HR_MSS_CT_POSN

(SQL Table)
Index Back

GSS Position Data

Record stores the position data information used by Guided Self Service position clone transaction. This record has a 1 to 1 relationship with HR_MSS_CT_DAT

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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 ACTION_DT_SS Date(10) DATE NOT NULL Termination Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Default Value: 00000000

    6 NEW_POS_NBR Character(8) VARCHAR2(8) NOT NULL New Position

    Default Value: 00000000

    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    10 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Default Value: NEW

    Prompt Table: ACTN_REASON_TBL

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

    Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT

    Prompt Table: BUSUNIT_HR_VW

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

    Prompt Table: DEPT_TBL

    13 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: HR_GSS_JOBCD_VW

    14 POSN_STATUS Character(1) VARCHAR2(1) NOT NULL Position Status
    A=Approved
    P=Proposed
    R=Frozen

    Default Value: A

    15 STATUS_DT Date(10) DATE Status Date
    16 MAX_HEAD_COUNT Number(4,0) SMALLINT NOT NULL Max Head Count

    Default Value: 1

    17 UPDATE_INCUMBENTS Character(1) VARCHAR2(1) NOT NULL Update Incumbents

    Y/N Table Edit

    Default Value: Y

    18 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA

    19 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    20 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Default Value: DEPT_TBL.COMPANY

    Prompt Table: COMPANY_TBL

    21 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    22 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

    Prompt Table: STDHRS_FREQ_VW

    23 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    24 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
    1=Day
    2=Evening
    3=Night
    A=Any
    C=Compressed
    N=Not Applicable
    R=Rotating

    Default Value: N

    25 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
    R=Regular
    T=Temporary

    Default Value: JOBCODE_TBL.REG_TEMP

    26 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time

    Default Value: F

    27 MON_HRS Number(5,2) DECIMAL(4,2) NOT NULL Monday
    28 TUES_HRS Number(5,2) DECIMAL(4,2) NOT NULL Tuesday
    29 WED_HRS Number(5,2) DECIMAL(4,2) NOT NULL Wednesday
    30 THURS_HRS Number(5,2) DECIMAL(4,2) NOT NULL Thursday
    31 FRI_HRS Number(5,2) DECIMAL(4,2) NOT NULL Friday
    32 SAT_HRS Number(5,2) DECIMAL(4,2) NOT NULL Saturday
    33 SUN_HRS Number(5,2) DECIMAL(4,2) NOT NULL Sunday
    34 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: OPR_DEF_TBL_HR.REG_REGION

    Prompt Table: REG_STANDARD_VW

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

    Prompt Table: SAL_PLAN_TBL

    36 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    37 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_VW

    38 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system

    Prompt Table: SUPVSR_LVL_TBL

    39 DESCRLONG Long Character CLOB Long Description
    40 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID

    Prompt Table: POOL_TBL

    41 ENCUMBER_INDC Character(1) VARCHAR2(1) NOT NULL Encumbrance Indicator
    I=Encumber Immediately
    N=No Encumbrance
    R=Encumber on Requisition

    Default Value: I

    42 ENCUMB_SAL_OPTN Character(3) VARCHAR2(3) NOT NULL Encumber Salary Option
    COM=Sum of Default Components
    MAX=Salary Grade Maximum
    MID=Salary Grade Midpoint
    MIN=Salary Grade Minimum
    STP=Salary Step
    USR=User Specified Amount

    Default Value: STP

    43 ENCUMB_SAL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Encumber Salary Amount
    44 CLASS_INDC Character(1) VARCHAR2(1) NOT NULL Classified/Unclassified Ind
    B=All
    C=Classified
    T=Temporary
    U=Unclassified

    Default Value: C

    45 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
    46 ADDS_TO_FTE_ACTUAL Character(1) VARCHAR2(1) NOT NULL Adds to FTE Actual Count

    Y/N Table Edit

    Default Value: N