HRS_DM_KEY_VW

(SQL View)
Index Back

Data mapping Key Table

Data mapping Key Table

SELECT HRS_DM_CAT_ID , HRS_DM_KEY_ID , HRS_DM_SUBCAT , HRS_DM_KEY_NAME , HRS_DM_DESCR , HRS_DM_FKEY FROM PS_HRS_DM_KEY

  • Related Language Record: HRS_DM_KEY_LVW
  • Parent record: HRS_DM_CAT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_DM_CAT_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Category ID
    2 HRS_DM_KEY_ID Number(15,0) DECIMAL(15) NOT NULL Data Mapping Key ID
    3 HRS_DM_SUBCAT Character(50) VARCHAR2(50) NOT NULL SubCategory
    4 HRS_DM_KEY_NAME Character(50) VARCHAR2(50) NOT NULL Data Mapping Key Name. This is what is shown in value mappings.
    5 HRS_DM_DESCR Character(254) VARCHAR2(254) NOT NULL Data Mapping Object Description
    6 HRS_DM_FKEY Character(40) VARCHAR2(40) NOT NULL Data Mapping Foreign Key. Used by Data mapping keys to store the key from the foreign table, for use when performing a sync operation.