RUN_CNTL_SFAUTO

(SQL Table)
Index Back

Mfg Auto Create Run Cntl

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
5 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
6 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
8 PRINT_BAR_CODE Character(1) VARCHAR2(1) NOT NULL Print Bar Code
9 PRINT_CNTL_FLG Character(1) VARCHAR2(1) NOT NULL Print Bar Coded Control Flags
10 SPW_PRINT_ATTACH Character(1) VARCHAR2(1) NOT NULL 3/26/98 rlk - Change rftlong to "Print Attachments" to work with run_sfs2003 panel
11 SPW_PRINT_TEXT Character(1) VARCHAR2(1) NOT NULL Shop Paper Work Print Text
12 SPW_PRINT_CFG Character(1) VARCHAR2(1) NOT NULL Print Config Detail
N=n
Y=y
13 DIS_PRINT_ORIGCOMP Character(1) VARCHAR2(1) NOT NULL 03/11/99 ST CN# EN800-1.0 Created field for Diaptch List Report and Production Report.
14 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID