HCI_SETID_VW

(SQL View)
Index Back

HCI TableSet ID view

TableSet ID view for Campus Integration. It cannot have long varchars.

SELECT SETID ,DESCR ,DESCRSHORT ,PARTIAL_SHARING FROM PS_SETID_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
4 PARTIAL_SHARING Character(1) VARCHAR2(1) NOT NULL Partial Sharing

Y/N Table Edit

Default Value: N