MIL_SVC_CMP_VW

(SQL View)
Index Back

Service Component view.

Military Service Component view.

SELECT DISTINCT B.MILITARY_SERVICE , A.MIL_SVC_COMP_CD , A.DESCR ,A.DESCRSHORT FROM PS_MIL_SVC_CMP_TBL A , PS_MIL_SERV_COMPNT B WHERE A.MIL_SVC_COMP_CD = B.MIL_SVC_COMP_CD

  • Related Language Record: MIL_SVC_CMP_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MILITARY_SERVICE Character(8) VARCHAR2(8) NOT NULL Military Service
    2 MIL_SVC_COMP_CD Character(4) VARCHAR2(4) NOT NULL Service Component
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description