HR_ATT_SUBID_VW

(SQL View)
Index Back

HR Attachments: SubIDs

HR Attachments: SubIDs for the Text Catalog

SELECT DISTINCT OBJECTOWNERID , HR_ATT_SUB_ID FROM PS_HR_ATT_KEYS_S

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HR_SSTEXT_KEY1 Character(30) VARCHAR2(30) NOT NULL 1st level generic key for Self-Service Text Catalog.
2 HR_ATT_SUB_ID Character(4) VARCHAR2(4) NOT NULL Field to partition attachments keys entries