HRS_ACMPH_TBL_I

(SQL View)
Index Back

Accomplishment Honor Intfc

Accomplishments for Honors and Awards Interface View

SELECT A.ACCOMPLISHMENT , A.DESCR , A.ACCOMP_CATEGORY , A.DESCRSHORT FROM PS_HRS_ACCOMP_TBL A WHERE A.ACCOMP_CATEGORY = 'HON'

  • Related Language Record: HRS_ACC_TBL_LNI
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Honor or Award
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
    DEG=Degree
    HON=Honor or Award
    LIC=License or Certification
    LNG=Language
    MEM=Membership
    NVQ=NVQ
    TST=Test
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ACCOMP_TBL.DESCR