EOFM_AWE_VW(SQL View) |
Index Back |
|---|
| SELECT F.SEQ_NBR , F.FORM_TYPE , T.PORTAL_LABEL , F.FORM_SUBJECT , 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
ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |
| 4 | FORM_SUBJECT | Character(100) | VARCHAR2(100) NOT NULL | Subject |
| 5 | EOFM_SUBMIT_BY | Character(30) | VARCHAR2(30) NOT NULL | Submit By |
| 6 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |