MIL_RANK_TBL

(SQL Table)
 Index Back

Military Ranks

This table describes all the ranks belonging to a Military Service.

  • Related Language Record: MIL_RANK_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service

    Prompt Table: MIL_SERVICE_TBL

    2 MIL_RANK Character(5) VARCHAR2(5) NOT NULL Military Rank
    3 MIL_SVC_SEQ_NBR Number(3,0) SMALLINT NOT NULL Service Sequence Number - This shows the relative ranking of an employee in the military service.
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 NATO_RANK_CODE Character(4) VARCHAR2(4) NOT NULL North American Treaty Organization (NATO) equivalent rank
    010=OR-01
    020=OR-02
    030=OR-03
    040=OR-04
    050=OR-05
    060=OR-06
    070=OR-07
    080=OR-08
    090=OR-09
    100=Student Officer
    105=OF(D)
    110=OF-01
    120=OF-02
    130=OF-03
    140=OF-04
    150=OF-05
    160=OF-06
    170=OF-07
    180=OF-08
    190=OF-09
    200=OF-10
    7 MIL_RANK_CATEGORY Character(2) VARCHAR2(2) NOT NULL Military Rank Category
    OF=Officer
    OR=Other Ranks
    WO=Warrant Officer
    8 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.

    Prompt Table: JPM_CAT_TYPES

    9 JPM_CAT_ITEM_ID Character(12) VARCHAR2(12) NOT NULL Catalog Item Id. Identifies a unique catalog item defintion within a catalog type.

    Prompt Table: JPM_CAT_ITEMS