PO_POCHGPRG_PRM

(SQL Table)
Index Back

Parm record for Stage Purge

# 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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 PROCESS_INST_STG Number(10,0) DECIMAL(10) NOT NULL Stage Record Process Instance
5 CHNG_SOURCE Character(3) VARCHAR2(3) NOT NULL Change Source
BPA=Contract Release to Single PO
CAP=Contract Batch Auto Approval
CRT=PAR Replenish/Close Backorders
CST=Close Short Purchase Orders
DRP=Order Management Referenced
EDX=PO Acknowledgments
EMC=Req. Requester Mass Change
EPO=eProcurement Change Request
EPR=User Change Request
IMC=Inventory Mass Change
ONL=On-line Purchase Order
PLN=Planning System
PMC=PO Buyer Mass Change
POC=PO Change Batch Process
PRD=Production/Shop Floor
6 PURGE_ERRS_FLG Character(1) VARCHAR2(1) NOT NULL Purge Staged Rows in Error

Y/N Table Edit

Default Value: Y

7 PURGE_COMPL_FLG Character(1) VARCHAR2(1) NOT NULL Purge Completed Stage Rows

Y/N Table Edit

Default Value: Y

8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

9 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
10 DATE_SEL_OPT Character(1) VARCHAR2(1) NOT NULL Date Selection
C=Current Date
M=Current Date Minus Days
N=No Selection by Date
P=Current Date Plus Days
S=Specified Date

Default Value: N

11 DATE_SEL_OPR Character(2) VARCHAR2(2) NOT NULL Date Selection Oper
<=Less Than Select Date
<==Less Than or Equal To Sel Date
<>=Not Equal to Selection Date
==Equal to Selection Date
>=Greater Than Selection Date
>==Greater Than or Eq to Sel Date
12 DATE_SEL_DT Date(10) DATE 03/23/2004 SFC Added PROD_COST_EFF_DT label
13 DATE_SEL_DAYS Number(3,0) SMALLINT NOT NULL Date Selection Number of Days
14 SELECTION_CRIT_LBL Character(1) VARCHAR2(1) NOT NULL Selection Criteria