GM_ELEMENT_VALUEPROF_ROLE_TYPESEQ_NBREMPLIDY/N Table Edit
Default Value: N
A=Approve
N=Notify
R=Review
Default Value: A
Y/N Table Edit
Default Value: N
B=Worklist/Email
E=Email Notification Only
W=Worklist Only
GM_PCL_WF_TMP(SQL Table) |
Index Back |
|---|---|
Protocol Workflow Rule Defn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GM_ELEMENT_VALUE |
Character(18) | VARCHAR2(18) NOT NULL | GM_ELEMENT_VALUE |
| 2 | PROF_ROLE_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Role Type |
| 3 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | GM_REQ_APPER | Character(1) | VARCHAR2(1) NOT NULL |
GM_REQ_APPER
Y/N Table Edit Default Value: N |
| 6 | GM_PERFORM_ACT | Character(1) | VARCHAR2(1) NOT NULL |
GM_PERFORM_ACT
A=Approve N=Notify R=Review Default Value: A |
| 7 | GM_REASSIGN | Character(1) | VARCHAR2(1) NOT NULL |
GM_REASSIGN
Y/N Table Edit Default Value: N |
| 8 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 9 | GM_WF_POOL | Character(1) | VARCHAR2(1) NOT NULL | Pool List |
| 10 | GM_WF_IN_PROG | Character(1) | VARCHAR2(1) NOT NULL |
Action When In Progress
B=Worklist/Email E=Email Notification Only W=Worklist Only |