SHEET_IDEX_SEC_S_KIB_VW(SQL View) |
Index Back |
|---|---|
EX - SF Security View for KIBUsed for Document Level Security on Expenses Insights. |
| SELECT DISTINCT A.SHEET_ID , 'U:' %Concat A.APPROVAL_OPRID FROM %Table(EX_ER_APPR_VW) A UNION SELECT DISTINCT B.EX_DOC_ID , 'U:' %Concat B.OPRID FROM %Table(EX_APRVL_HIST) B WHERE B.EX_DOC_TYPE = 'S' AND B.ACTION_NAME NOT IN ('SUB', 'DEL', 'RES') AND B.APPROVER_PROFILE <> 'Employee' AND B.OPRID IN (SELECT D.OPRID FROM PS_EX_EE_JOB_DT_VW C, PSOPRDEFN D WHERE C.SUPERVISOR_ID = D.EMPLID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | EX_SECURITY_REPORT | Character(40) | VARCHAR2(40) NOT NULL | EX - Security Attribute for Expense Report document level security. |