CS_DOC_IDCS_DOC_SES_VW(SQL View) |
Index Back |
|---|---|
SCMT Document Security |
| SELECT HDR.CS_DOC_ID , 'U:' %Concat HDR.CS_DOC_OWNER FROM PS_CS_DOC_HDR HDR UNION SELECT USR.CS_DOC_ID , 'U:' %Concat USR.CS_COLLAB_OPRID FROM PS_CS_DOC_COL_USER USR UNION SELECT ROL.CS_DOC_ID , 'R:' %Concat ROL.ROLENAME FROM PS_CS_DOC_ROLE_ACC ROL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CS_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Document ID |
| 2 | CS_DOC_SECURITY | Character(75) | VARCHAR2(75) NOT NULL | Document Security |