SF_PRDNID_HEADR (SQL Table)	Index Back
Production ID's Header 9/8/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement 9/15/97 MEG CN#SF750-4.0: Set prompt table for config_code to cp_config_vw. CN#EG750-4.0 dbe (Engineering Routings) - Added RTG_STATE to statements referencing EN_RTG_* tables. 9/19/97 JNW CN#PL750-DI-GPENN-52 ERA Net Change 1. added net_change_ep 2. sf_prdnid_headr.production_id.fieldformula (add logic for net_change_ep) 3. sf_prdnid_headr.plan_change_flg.saveprechg (add logic for net_change_ep) 11/24/97 SCC CN#PL750-DI-SCHEW-109: Add PROD_PRCS_STATUS 03/12/98 SCC CN#SCHEW-GP92Y: Add new_revision 4. 05/27/1998 Lee (RTNT159-IQ8N0): new_start_date Blank-out the production due date and shift, when FWD scheduling and the start date are changed and the user hits the tab button, versus the save button. new_end_date Blank-out the production start date and shift, when BWD scheduling and the due date are changed, and the user hits the tab button, versus the save button. CN# EN800-3.0, Sep 21 98, Anna Added field BomCode CN# PL800-10.0 Nov 6th 98 Added Field FROZEN_SUBSTITUTES and modified existing code to accomodate 'FIRMED_STATUS cn# en800-8.0 11/14/98 ewb - add prompt table to bom code CN# SF800-13.0 12/31/98 jnw - added field trdn_orig_pid CN#EN800-6.00 4/16/99 ddp - re-create output list if bom code, due/start date, prdn qty change on released order. CN#SF800-18.0 4/18/1999 WHS - Various changes to allow new_prdn_qty to change on INPROCESS production orders. CN#SF800-28.0 4/29/99 WHS - Various changes to allow prod_status to be moved from INPROCESS to a prior status. CN#EN800-6.0 5/20/99 DDP - Added new panelgroup for comp maint schedules. 06/10/99 SPL CN# MG800-11.0 Added possible hiding of configuration code for PRDN_STATUS_MA to RowInit PeopleCode for Prod_Status. 10/18/99 CN#SF800-14.0 TKI Added call to set_prompt to ensure the correct setting of prompt tables for BOM and Routing code 12/14/99 TKI In REF_ROUTING_ITEM SaveEdit, added check to see if PRODUCTION_TYPE has changed; if it has, you will want to recopy the output and comp lists 10/02/02 PWF CN#MG880-SERIAL ADDED SERIAL_IN_PRDN into table

SF_PRDNID_HEADR

(SQL Table)

Production ID's Header

9/8/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement 9/15/97 MEG CN#SF750-4.0: Set prompt table for config_code to cp_config_vw. CN#EG750-4.0 dbe (Engineering Routings) - Added RTG_STATE to statements referencing EN_RTG_* tables. 9/19/97 JNW CN#PL750-DI-GPENN-52 ERA Net Change 1. added net_change_ep 2. sf_prdnid_headr.production_id.fieldformula (add logic for net_change_ep) 3. sf_prdnid_headr.plan_change_flg.saveprechg (add logic for net_change_ep) 11/24/97 SCC CN#PL750-DI-SCHEW-109: Add PROD_PRCS_STATUS 03/12/98 SCC CN#SCHEW-GP92Y: Add new_revision 4. 05/27/1998 Lee (RTNT159-IQ8N0): new_start_date Blank-out the production due date and shift, when FWD scheduling and the start date are changed and the user hits the tab button, versus the save button. new_end_date Blank-out the production start date and shift, when BWD scheduling and the due date are changed, and the user hits the tab button, versus the save button. CN# EN800-3.0, Sep 21 98, Anna Added field BomCode CN# PL800-10.0 Nov 6th 98 Added Field FROZEN_SUBSTITUTES and modified existing code to accomodate 'FIRMED_STATUS cn# en800-8.0 11/14/98 ewb - add prompt table to bom code CN# SF800-13.0 12/31/98 jnw - added field trdn_orig_pid CN#EN800-6.00 4/16/99 ddp - re-create output list if bom code, due/start date, prdn qty change on released order. CN#SF800-18.0 4/18/1999 WHS - Various changes to allow new_prdn_qty to change on INPROCESS production orders. CN#SF800-28.0 4/29/99 WHS - Various changes to allow prod_status to be moved from INPROCESS to a prior status. CN#EN800-6.0 5/20/99 DDP - Added new panelgroup for comp maint schedules. 06/10/99 SPL CN# MG800-11.0 Added possible hiding of configuration code for PRDN_STATUS_MA to RowInit PeopleCode for Prod_Status. 10/18/99 CN#SF800-14.0 TKI Added call to set_prompt to ensure the correct setting of prompt tables for BOM and Routing code 12/14/99 TKI In REF_ROUTING_ITEM SaveEdit, added check to see if PRODUCTION_TYPE has changed; if it has, you will want to recopy the output and comp lists 10/02/02 PWF CN#MG880-SERIAL ADDED SERIAL_IN_PRDN into table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
Default Value: NEXT

3 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled

4 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
Prompt Table: SF_PRDN_AREA

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: SF_PA_IT_ID_VW

6 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
Default Value: PR

7 ORIG_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Original Production Qty

8 ORIG_PRDN_END_QTY Number(12,4) DECIMAL(11,4) NOT NULL Expected Prdn Qty

9 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure

10 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty

11 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty

12 NEW_UOM Character(3) VARCHAR2(3) NOT NULL Unit of Measure

13 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
Prompt Table: %EDITTABLE

14 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
Prompt Table: %EDITTABLE2

15 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item

16 SCHEDULING_METHOD Character(3) VARCHAR2(3) NOT NULL Scheduling Method
BWD=Backward
FWD=Forward

17 ORIG_START_DATE Date(10) DATE Original Start Date

18 ORIG_START_TIME Time(15) TIMESTAMP Original Start Time

19 ORIG_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Original Start Shift

20 ORIG_END_DATE Date(10) DATE Original Due Date

21 ORIG_END_TIME Time(15) TIMESTAMP Original DueTime

22 ORIG_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Original Due Shift

23 NEW_START_DATE Date(10) DATE Start Date

24 NEW_START_TIME Time(15) TIMESTAMP Start Time

25 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift

26 NEW_END_DATE Date(10) DATE Due Date

27 NEW_END_TIME Time(15) TIMESTAMP Due Time

28 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift

29 PRDN_START_DATE Date(10) DATE Prdn Start Date

30 PRDN_START_TIME Time(15) TIMESTAMP Prdn Start Time

31 PRDN_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Start Shift

32 PRDN_DUE_DATE Date(10) DATE Prdn Due Date

33 PRDN_DUE_TIME Time(15) TIMESTAMP Prdn Due Time

34 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift

35 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
Prompt Table: EN_REV_SRCH

36 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty

37 SCRAP_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty

38 ADJ_FIXED_SCRAP Number(12,4) DECIMAL(11,4) NOT NULL Adjusted Fixed Scrap Qty

39 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct

40 COMP_CLOSE_DT Date(10) DATE Date of Completion

41 COMP_CLOSE_TIME Time(15) TIMESTAMP Time of Completion

42 LAB_CLOSE_DT Date(10) DATE Labor Close Date

43 LAB_CLOSE_TIME Time(15) TIMESTAMP Labor Close Time

44 ACCTG_CLOSE_DT Date(10) DATE Accounting Close Date

45 ACCTG_CLOSE_TIME Time(15) TIMESTAMP Accounting Close Time

46 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

47 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
N=No
Y=Yes
Y/N Table Edit

48 PLAN_CHANGE_FLG Character(1) VARCHAR2(1) NOT NULL Change Indicator (Planning)
Y/N Table Edit
Default Value: Y

49 NET_CHANGE_EP Character(1) VARCHAR2(1) NOT NULL Enterprise Planning Net Change
Y/N Table Edit
Default Value: Y

50 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
Default Value: N

51 LINK_TO_OM Character(1) VARCHAR2(1) NOT NULL Link to Order Management
Y/N Table Edit
Default Value: N

52 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

53 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

54 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

55 CP_COMP_SEQ Number(3,0) SMALLINT NOT NULL Component Sequence Field

56 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
Prompt Table: CP_CONFIG_VW

57 PRINT_DOC Character(2) VARCHAR2(2) NOT NULL Print Prdn Documents
10=Do not Print
20=Ready for Printing
30=Printed

58 PRINT_COUNT Number(3,0) SMALLINT NOT NULL Print Count
Default Value: 0

59 PRDN_CREATED_DTTM DateTime(26) TIMESTAMP Production Created DateTime

60 LAST_DTTM_UPDATE 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.

61 PROD_PRCS_STATUS Character(2) VARCHAR2(2) NOT NULL 3/1/99 crc CN#PL800-10.0 FPO added 2 new flags(T and U) for remote cal
C=Delete Comp List & Reschedule
D=Delete Comp List Only
N=No Action
R=Reschedule Only
S=Start Release -S
T=Start Release -T
U=Start Release -U
Default Value: N

62 NEW_REVISION Character(4) VARCHAR2(4) NOT NULL New Revision

63 PROCESSED_CD Character(1) VARCHAR2(1) NOT NULL Processed Code
E=Processed with Error
I=In Process
N=Not Processed
Y=Processed
Default Value: N

64 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

65 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes
Default Value: N

66 TRDN_ORIG_PID Character(10) VARCHAR2(10) NOT NULL 1/1/99 jnw (CN#SF800-13) added field

67 SERIAL_IN_PRDN Character(1) VARCHAR2(1) NOT NULL Serial in Production
Y/N Table Edit
Default Value: MASTER_ITEM_TBL.SERIAL_IN_PRDN

68 CUM_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Expected Yield %
Default Value: 100

69 SF_YIELD_COST_FLG Character(1) VARCHAR2(1) NOT NULL Yield Cost Flag
Y/N Table Edit
Default Value: N

70 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW
2	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID Default Value: NEXT
3	PROD_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Production Status 10=Entered 15=Firmed 20=Released 30=In Process 40=Pend Cmpl 50=Completed 60=Clsd/Labor 70=Clsd/Acctg 90=Canceled
4	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area Prompt Table: SF_PRDN_AREA
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: SF_PA_IT_ID_VW
6	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown Default Value: PR
7	ORIG_PRDN_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Original Production Qty
8	ORIG_PRDN_END_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Expected Prdn Qty
9	ORIG_UOM	Character(3)	VARCHAR2(3) NOT NULL	Original Unit of Measure
10	NEW_PRDN_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Production Start Qty
11	EXPECTED_PRDN_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Production End Qty
12	NEW_UOM	Character(3)	VARCHAR2(3) NOT NULL	Unit of Measure
13	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database Prompt Table: %EDITTABLE
14	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code Prompt Table: %EDITTABLE2
15	REF_ROUTING_ITEM	Character(18)	VARCHAR2(18) NOT NULL	Reference Routing Item
16	SCHEDULING_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Scheduling Method BWD=Backward FWD=Forward
17	ORIG_START_DATE	Date(10)	DATE	Original Start Date
18	ORIG_START_TIME	Time(15)	TIMESTAMP	Original Start Time
19	ORIG_START_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Original Start Shift
20	ORIG_END_DATE	Date(10)	DATE	Original Due Date
21	ORIG_END_TIME	Time(15)	TIMESTAMP	Original DueTime
22	ORIG_END_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Original Due Shift
23	NEW_START_DATE	Date(10)	DATE	Start Date
24	NEW_START_TIME	Time(15)	TIMESTAMP	Start Time
25	NEW_START_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Start Shift
26	NEW_END_DATE	Date(10)	DATE	Due Date
27	NEW_END_TIME	Time(15)	TIMESTAMP	Due Time
28	NEW_END_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Due Shift
29	PRDN_START_DATE	Date(10)	DATE	Prdn Start Date
30	PRDN_START_TIME	Time(15)	TIMESTAMP	Prdn Start Time
31	PRDN_START_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Prdn Start Shift
32	PRDN_DUE_DATE	Date(10)	DATE	Prdn Due Date
33	PRDN_DUE_TIME	Time(15)	TIMESTAMP	Prdn Due Time
34	PRDN_DUE_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Prdn Due Shift
35	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label Prompt Table: EN_REV_SRCH
36	COMPLETED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Completed Qty
37	SCRAP_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
38	ADJ_FIXED_SCRAP	Number(12,4)	DECIMAL(11,4) NOT NULL	Adjusted Fixed Scrap Qty
39	PERCENT_COMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Scrap Prdn Pct
40	COMP_CLOSE_DT	Date(10)	DATE	Date of Completion
41	COMP_CLOSE_TIME	Time(15)	TIMESTAMP	Time of Completion
42	LAB_CLOSE_DT	Date(10)	DATE	Labor Close Date
43	LAB_CLOSE_TIME	Time(15)	TIMESTAMP	Labor Close Time
44	ACCTG_CLOSE_DT	Date(10)	DATE	Accounting Close Date
45	ACCTG_CLOSE_TIME	Time(15)	TIMESTAMP	Accounting Close Time
46	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
47	MA_PRDN_ID_FLG	Character(1)	VARCHAR2(1) NOT NULL	10/18/99 SCC CN#IC800: Add label MAINTAIN_PID N=No Y=Yes Y/N Table Edit
48	PLAN_CHANGE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Change Indicator (Planning) Y/N Table Edit Default Value: Y
49	NET_CHANGE_EP	Character(1)	VARCHAR2(1) NOT NULL	Enterprise Planning Net Change Y/N Table Edit Default Value: Y
50	PLAN_FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	11/01/01 PCL (CN#PL900-1): Updated N=No Y=Yes Default Value: N
51	LINK_TO_OM	Character(1)	VARCHAR2(1) NOT NULL	Link to Order Management Y/N Table Edit Default Value: N
52	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
53	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
54	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
55	CP_COMP_SEQ	Number(3,0)	SMALLINT NOT NULL	Component Sequence Field
56	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator Prompt Table: CP_CONFIG_VW
57	PRINT_DOC	Character(2)	VARCHAR2(2) NOT NULL	Print Prdn Documents 10=Do not Print 20=Ready for Printing 30=Printed
58	PRINT_COUNT	Number(3,0)	SMALLINT NOT NULL	Print Count Default Value: 0
59	PRDN_CREATED_DTTM	DateTime(26)	TIMESTAMP	Production Created DateTime
60	LAST_DTTM_UPDATE	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.
61	PROD_PRCS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	3/1/99 crc CN#PL800-10.0 FPO added 2 new flags(T and U) for remote cal C=Delete Comp List & Reschedule D=Delete Comp List Only N=No Action R=Reschedule Only S=Start Release -S T=Start Release -T U=Start Release -U Default Value: N
62	NEW_REVISION	Character(4)	VARCHAR2(4) NOT NULL	New Revision
63	PROCESSED_CD	Character(1)	VARCHAR2(1) NOT NULL	Processed Code E=Processed with Error I=In Process N=Not Processed Y=Processed Default Value: N
64	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
65	FROZEN_SUBSTITUTES	Character(1)	VARCHAR2(1) NOT NULL	Frozen Substitutes B=Both N=No Y=Yes Default Value: N
66	TRDN_ORIG_PID	Character(10)	VARCHAR2(10) NOT NULL	1/1/99 jnw (CN#SF800-13) added field
67	SERIAL_IN_PRDN	Character(1)	VARCHAR2(1) NOT NULL	Serial in Production Y/N Table Edit Default Value: MASTER_ITEM_TBL.SERIAL_IN_PRDN
68	CUM_YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Expected Yield % Default Value: 100
69	SF_YIELD_COST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Yield Cost Flag Y/N Table Edit Default Value: N
70	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text