| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
|
| 2 |
 PCL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
PCL_ID
|
| 3 |
PCL_VRSN_ID |
Character(7) |
VARCHAR2(7) NOT NULL |
PCL_VRSN_ID
|
| 4 |
APPROVER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Approver ID
Default Value: PSOPRDEFN.EMPLID
|
| 5 |
PROF_ROLE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Role Type
|
| 6 |
GM_REQ_APPER |
Character(1) |
VARCHAR2(1) NOT NULL |
GM_REQ_APPER
Y/N Table Edit
Default Value: N
|
| 7 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 8 |
GM_PERFORM_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
GM_PERFORM_ACT
A=Approve
N=Notify
R=Review
Default Value: A
|
| 9 |
GM_REASSIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
GM_REASSIGN
Y/N Table Edit
Default Value: N
|
| 10 |
GM_DISPOSITION |
Character(4) |
VARCHAR2(4) NOT NULL |
Disposition
APPR=Approved
DEND=Denied
REAS=Re-Assign Approver
RETD=Returned
RETN=Re-Assign Review Type
REV=Reviewed
|
| 11 |
GM_WF_IN_PROG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action When In Progress
B=Worklist/Email
E=Email Notification Only
W=Worklist Only
|
| 12 |
GM_WF_POOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Pool List
Y/N Table Edit
|
| 13 |
DISPOSITION_COMM |
Character(254) |
VARCHAR2(254) NOT NULL |
Disposition Comments
|
| 14 |
COM_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Committee Id. Used in Grants Protocol Setup
Prompt Table:
GM_PCL_COM_HDR
|
| 15 |
GM_APPROVAL_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Requirments
A=All Approvers Required
P=Pecent of Approvers Required
|
| 16 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 17 |
APPROVED_BY |
Character(11) |
VARCHAR2(11) NOT NULL |
APPROVED_BY
|
| 18 |
MEET_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Meeting Id. Used in Grants Protocol Setup
Prompt Table:
GM_PCL_COM_MEET
|
| 19 |
DISPOSITION_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a given transaction is approved by an oper
|
| 20 |
NOTES |
Long Character |
CLOB |
Budget Notes
|