MIL_TMPL_DEFN

(SQL Table)
 Index Back

Military Rank Template Defn

This table is used to define templates which will be used to default as much data as possible into the rank change control component.

  • Parent Record Of MIL_TMPL_LNG MIL_TMPL_STKHLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MIL_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Military Rank Template unique identifier
    2 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: RANK_CHNG_STAT

    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

    Prompt Table: MIL_TMPL_STATUS
    Set Control Field: ACTION

    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 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL
    Set Control Field: ACTION

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

    Prompt Table: BUSUNIT_HR_VW

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

    Prompt Table: DEPT_TBL

    10 MIL_RESP_CAR_MGR Character(4) VARCHAR2(4) NOT NULL Responsible Career Manager
    POSN=Position Number
    ROLE=Role

    Default Value: POSN

    11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSN_DATA_VW

    12 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_VW

    13 MIL_APRV_START_SW Character(2) VARCHAR2(2) NOT NULL Approval Start Switch
    FU=Future Date
    IM=Immediately (Current Date)

    Default Value: IM

    14 MIL_FUTURE_DAYS Number(3,0) SMALLINT NOT NULL Number of Future Days
    15 MIL_PRENOTIFY_CALC Number(3,0) SMALLINT NOT NULL Prenotificatiion Dt=EffDt-Days
    16 COMMENTS Long Character CLOB Comment