RSEC_SL_HOLD_VW(SQL View) |
Index Back |
---|---|
Catalog Select View RecordView record for selecting key fields that will be inserted into the security list record. |
SELECT A.SYNCID , A.SETID , A.HOLD_CD FROM PS_RO_DEFN_HOLD A |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | The related synchronization id stores the syncid of the primary record of the security object. This field is used in creating the security list record. | |
2 | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. | |
3 | HOLD_CD | Character(6) | VARCHAR2(6) NOT NULL | This field determine the hold code of an item. |