SEQ_NBR0=All
A=Approved
C=Cancelled
E=Denied
H=On Hold
I=Initial
P=Pending Approval
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low
EOFM_FORM_VW(SQL View) |
Index Back |
|---|
| SELECT F.SEQ_NBR , F.FORM_TYPE , T.PORTAL_LABEL , F.FORM_SUBJECT , F.FORM_APPR_STATUS , F.FORM_PRIORITY , F.CREATED_DTTM , F.LASTUPDDTTM , F.EOFM_SUBMIT_DTTM , F.EOFM_SUBMIT_BY , O.OPRDEFNDESC FROM PS_FORM F , PS_FORM_TYPE T , PSOPRDEFN O WHERE F.FORM_TYPE = T.FORM_TYPE AND F.EOFM_SUBMIT_BY = O.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 2 | FORM_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Form and Builder Field |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 4 | FORM_SUBJECT | Character(100) | VARCHAR2(100) NOT NULL | Subject |
| 5 | 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 |
| 6 | FORM_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low |
| 7 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Datetime |
| 8 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 9 | EOFM_SUBMIT_DTTM | DateTime(26) | TIMESTAMP | Submitted Datetime |
| 10 | EOFM_SUBMIT_BY | Character(30) | VARCHAR2(30) NOT NULL | Submit By |
| 11 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |