OPRIDSEQ_NBRPrompt Table: FORM_TYPE
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low
0=All
A=Approved
C=Cancelled
E=Denied
H=On Hold
I=Initial
P=Pending Approval
FORM_APPR_VW2(SQL View) |
Index Back |
|---|---|
Form Approval ViewForm Approval View |
| SELECT A.OPRID , B.SEQ_NBR , D.PORTAL_LABEL , C.FORM_TYPE , C.FORM_SUBJECT , C.FORM_PRIORITY , C.FORM_DUE_DATE , XREF.EODC_DOC_KEY , C.FORM_APPR_STATUS FROM PS_EOAW_STEP_VW A , PS_FORM_AW B , PS_FORM C LEFT OUTER JOIN PS_EODC_FORM_XREF XREF ON C.FORM_TYPE = XREF.SD_RECNAME AND C.SEQ_NBR = XREF.SEQ_NBR , PS_FORM_TYPE D WHERE A.EOAWPRCS_ID = 'FormApproval' AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.SEQ_NBR = C.SEQ_NBR AND C.FORM_TYPE = D.FORM_TYPE AND ((A.EOAWSTEP_STATUS = 'P' OR A.EOAWSTEP_STATUS = 'A' OR A.EOAWSTEP_STATUS = 'D' OR A.EOAWSTEP_STATUS = 'H') OR A.EOAWUSER_TYPE = 'R') AND A.EOAWTHREAD_ID = ( SELECT MAX(AA.EOAWTHREAD_ID) FROM PS_EOAW_STEP_VW AA WHERE AA.EOAWPRCS_ID = 'FormApproval' AND AA.EOAWTHREAD_ID = B.EOAWTHREAD_ID ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 4 | FORM_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Form and Builder Field
Prompt Table: FORM_TYPE |
| 5 | FORM_SUBJECT | Character(100) | VARCHAR2(100) NOT NULL | Subject |
| 6 | FORM_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low |
| 7 | FORM_DUE_DATE | Date(10) | DATE | Due Date |
| 8 | EODC_DOC_KEY | Character(150) | VARCHAR2(150) NOT NULL | Document Key String |
| 9 | FORM_APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
work order approval status
0=All A=Approved C=Cancelled E=Denied H=On Hold I=Initial P=Pending Approval |