EOAWAPPROVER_OPRIDMSGNODENAMEL=Large Form
M=Medium Form
S=Small Form
X=Extra Large Form
N=False
Y=True
Y/N Table Edit
Default Value: N
H=History Mode
P=Pending Mode
S=Search Mode
Default Value: P
EOAWMSUMMROOTVW(SQL View) |
Index Back |
|---|---|
Approvals Summary Message View |
| SELECT X.EOAWAPPROVER_OPRID , N.MSGNODENAME , 'X' , 'N' , 'P' , 0 , 'N' , 0 , 0 , OPRDEFNDESC , 0 , ' ' FROM PSOPRDEFN O , PSMSGNODEDEFN N , ( SELECT DISTINCT EOAWAPPROVER_OPRID FROM PS_EOAW_SUMM_DTL D , PS_EOAW_SUMMARY S WHERE D.EOAWPRCS_ID = S.EOAWPRCS_ID AND D.EOAWTHREAD_ID = S.EOAWTHREAD_ID) X WHERE O.OPRID = X.EOAWAPPROVER_OPRID AND N.LOCALDEFAULTFLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOAWAPPROVER_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Approver Operator ID |
| 2 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 3 | EOPCFORM_FACTOR | Character(1) | VARCHAR2(1) NOT NULL |
Page Composer form factor
L=Large Form M=Medium Form S=Small Form X=Extra Large Form |
| 4 | EOAW_ADMIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Is Administrative
N=False Y=True Y/N Table Edit Default Value: N |
| 5 | EOAW_RUN_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Run Mode
H=History Mode P=Pending Mode S=Search Mode Default Value: P |
| 6 | EOAWMA_COUNT | Number(6,0) | INTEGER NOT NULL | Fluid Approval pending count |
| 7 | EOAW_EXCOUNT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Exceed Limitation Count |
| 8 | EOAWMA_COUNTER | Number(6,0) | INTEGER NOT NULL | Counter |
| 9 | EOAWMA_CHUNK_SIZE | Number(6,0) | INTEGER NOT NULL | Chunk Size |
| 10 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 11 | EOAWRESPONSESTATUS | Signed Number(11,0) | DECIMAL(10) NOT NULL | Response Status |
| 12 | EOAWRESPONSETEXT | Character(254) | VARCHAR2(254) NOT NULL | Response Text |