EOAWMAPPRROOTVW

(SQL View)
Index Back

Root record for mass approvals


SELECT ' ' , 'P' , ' ' , 'N' , 'N' , ' ' , 0 , ' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Operator ID
2 EOAW_MASS_ACTION Character(12) VARCHAR2(12) NOT NULL Mass Action
3 EOAWREASSIGNOPRID Character(30) VARCHAR2(30) NOT NULL Approval Framework Reassign Oprid
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_PREVIEW_FLG Character(1) VARCHAR2(1) NOT NULL Preview
6 COMMENTS Long Character CLOB Comment
7 EOAWRESPONSESTATUS Signed Number(11,0) DECIMAL(10) NOT NULL Response Status
8 EOAWRESPONSETEXT Character(254) VARCHAR2(254) NOT NULL Response Text