SCC_TM_PTPRVSET

(SQL View)
Index Back

SELECT PTAI_PRIVSET_ID ,DESCR ,DESCR254 ,PTAI_FEATURE ,ACTIVE_FLAG ,PTAI_SYSTEM_ITEM FROM ps_PTAI_PRIVSET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TM_PTAIPRIVID Character(30) VARCHAR2(30) NOT NULL Privilege Set ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 SCC_TM_PTAIFEATURE Character(4) VARCHAR2(4) NOT NULL Privilege Type
5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
6 SCC_TM_PTAISYSITEM Character(1) VARCHAR2(1) NOT NULL System Item