MIL_RANK_STATUS

(SQL Table)
 Index Back

Rank Change Status Set Up Tabl

This table is intended to limit the number of allowable Action table values for this feature. Only those actions that are defined here will be visible on the Action and STatus prompts on the rank change control page.

  • Related Language Record: MIL_RNK_ST_LNG

  • Parent Record Of MIL_RANK_ST_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 MIL_RANK_CHNG_STAT Character(4) VARCHAR2(4) NOT NULL Disposition Status
    AMD=Amendment
    CNA=Cancel by Administrator
    CNC=Cancel by Command
    NEW=New
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 MIL_INCL_PRENOTIFY Character(1) VARCHAR2(1) NOT NULL Include in Prenotification

    Y/N Table Edit

    Default Value: N

    8 MIL_APPLY_JOB_SW Character(1) VARCHAR2(1) NOT NULL Apply Row to Job Switch

    Default Value: Y

    9 MIL_EARLY_REVW_SW Character(2) VARCHAR2(2) NOT NULL Early Review Switch
    JE=JOB.EFFDT + Number of Weeks
    NA=No Affect
    SC=Special Calculation Routine

    Default Value: NA

    10 MIL_EARLY_REVW_NBR Number(3,0) SMALLINT NOT NULL Number of Weeks
    11 COMMENTS Long Character CLOB Comment