RUN_CNTL_FPAUTO

(SQL Table)
Index Back

Mfg Flow Auto Run Control

# 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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

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

Default Value: N

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 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
8 PRINT_BAR_CODE Character(1) VARCHAR2(1) NOT NULL Print Bar Code

Default Value: N

9 PRINT_CNTL_FLG Character(1) VARCHAR2(1) NOT NULL Print Bar Coded Control Flags

Default Value: N

10 LABEL_FORMAT_ID Character(30) VARCHAR2(30) NOT NULL Format ID
11 FILE_DIRECTORY Character(80) VARCHAR2(80) NOT NULL File Directory
12 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
13 SF_RPL_LABEL_OPT Character(1) VARCHAR2(1) NOT NULL Create File for Labels

Default Value: N