BCT_MG_ACT_TMP

(SQL Table)
Index Back

Actual Hours Batch Temp Record

03/26/99 RSX CN# SF800-10.0 - Actual Hours temporary record for batch load process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
3 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
4 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID
8 DEVICE_LAST_SEQ Number(5,0) INTEGER NOT NULL Device Last Sequence Number
9 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
10 DTTM_STAMP 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.
11 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 SF_BOM_RTG_EFFDT Date(10) DATE 12/28/98,eyz, CN#EN800-4.0, new this as a workfield in Completions for the Recipe Management feature.
14 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
15 SF_ENTRY_DATE Date(10) DATE Entry Date
16 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
17 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
18 CREW_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Crew Reporting
19 MACH_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Machine Reporting
20 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
21 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
22 LAB_SETUP Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Setup
23 LAB_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Run
24 LAB_FIXED_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Fixed Run
25 LAB_POSTPROD Signed Number(10,2) DECIMAL(8,2) NOT NULL Labor Post Production
26 MACH_SETUP Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Setup
27 MACH_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Run
28 MACH_FIXED_RUN Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Fixed Run
29 MACH_POSTPROD Signed Number(10,2) DECIMAL(8,2) NOT NULL Machine Post Production