RUN_CNTL_EM_PRO

(SQL Table)
Index Back

Run Control for eS Proposals

Run control for deleteing expired and cancelled proposals

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 EM_VCHR_PROC Character(1) VARCHAR2(1) NOT NULL Invoice Processing
0=Specify Buyers
1=All Buyers

Default Value: 1

6 EXPIRE_DT Date(10) DATE Expiration Dt
7 EM_PROPOSAL_PROC Character(1) VARCHAR2(1) NOT NULL Proposal Processing
C=Cancelled Only
E=All Expired Proposals

Default Value: E