RECNAME_SJTRECNAME_SJT_VW(SQL View) |
Index Back |
|---|---|
ScrtyTypeTbl and ScrtySet VW |
| SELECT DISTINCT A.RECNAME_SJT FROM PS_SCRTY_SET_TBL A , PS_SCRTY_TYPE_TBL B WHERE A.SCRTY_SET_CD = B.SCRTY_SET_CD AND B.ENABLED = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME_SJT |
Character(15) | VARCHAR2(15) NOT NULL | Name of the Security Join Table for the Transaction side of this Security Access Type. "What is being secured". This is not a required field as not all "whats" will need a SJT table. |