HRS_DM_DGREE_VW

(SQL View)
Index Back

Education Degree Table

Use DEGREE_TBL to list the degrees to use as an edit table for DEGREE in your database.

SELECT A.ACCOMPLISHMENT , A.DESCR , A.DESCRSHORT ,' ' FROM PS_HRS_ACCOM_TBL_I A WHERE ACCOMP_CATEGORY='DEG'

  • Related Language Record: HRS_DM_DGREE_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_DM_KEY_NAME Character(50) VARCHAR2(50) NOT NULL Data Mapping Key Name. This is what is shown in value mappings.
    2 HRS_DM_DESCR Character(254) VARCHAR2(254) NOT NULL Data Mapping Object Description
    3 HRS_DM_FKEY Character(30) VARCHAR2(30) NOT NULL Data Mapping Forigen Key. Used by Data mapping keys to store the key from the forigen table, for use when performing a sync operation.
    4 HRS_DM_SUBCAT Character(50) VARCHAR2(50) NOT NULL SubCategory