RE_SAR_APPR_VW(SQL View) |
Index Back |
|---|---|
SAR Approval ViewSAR Approval View |
| SELECT DISTINCT A.BUSINESS_UNIT ,X.SAR_ID ,A.SAR_NAME ,A.SAR_STATUS ,A.SITE_TYPE ,U.EOAWSTEP_STATUS ,U.OPRID FROM PS_RE_SAR_DETAIL A , PS_RE_SAR_FIN_XREF X , PS_EOAW_STEPINST S ,PS_EOAW_USERINST U WHERE A.SAR_ID = X.SAR_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND X.EOAWTHREAD_STATUS <> 'T' UNION SELECT DISTINCT A.BUSINESS_UNIT ,X.SAR_ID ,A.SAR_NAME ,A.SAR_STATUS ,A.SITE_TYPE ,U.EOAWSTEP_STATUS ,U.OPRID FROM PS_RE_SAR_DETAIL A , PS_RE_SAR_XREF X , PS_EOAW_STEPINST S ,PS_EOAW_USERINST U WHERE A.SAR_ID = X.SAR_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND X.EOAWTHREAD_STATUS <> 'T' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SAR_ID | Character(15) | VARCHAR2(15) NOT NULL | SAR ID |
| 3 | SAR_NAME | Character(60) | VARCHAR2(60) NOT NULL | Site Acquisition Request Name |
| 4 | SAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
SAR Status
1=Pending 2=Active 3=Evaluating Finalists 4=Sites Selected 5=Finalised 6=Cancel |
| 5 | SITE_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Site Type |
| 6 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |