CE_PID_PROG_VW1 (SQL View)	Index Back
PID Proactive & Output Costs 3/21/03 lee: Initial create. Used in the PID Progress Inquiry.

CE_PID_PROG_VW1

(SQL View)

PID Proactive & Output Costs

3/21/03 lee: Initial create. Used in the PID Progress Inquiry.

SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.PRODUCTION_ID , A.SF_PRDN_PER_COMPL , B.TOTAL_FRZN_STD , A.EXTENDED_COST_TOT FROM PS_CE_BUBK_PID_VW1 A , PS_CM_PID_FZST_VW2 B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID (+)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUMGOP_NONVW

2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
Prompt Table: CM_BU_BOOK_TBL

3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
Prompt Table: SF_PRID_H_VW

4 SF_PRDN_PER_COMPL Number(10,2) DECIMAL(9,2) NOT NULL 10/21/98, eyz CN#800-6.0, added for Co-By Product Completions 11/04/99 MDS CN#EN800-6.0: Changed from 999.99 to 9999.99.

5 TOTAL_FRZN_STD Signed Number(23,4) DECIMAL(21,4) NOT NULL Frozen Standard

6 EXTENDED_COST_TOT Signed Number(16,2) DECIMAL(14,2) NOT NULL Latest Cost Measure

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUMGOP_NONVW
2	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book Prompt Table: CM_BU_BOOK_TBL
3	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID Prompt Table: SF_PRID_H_VW
4	SF_PRDN_PER_COMPL	Number(10,2)	DECIMAL(9,2) NOT NULL	10/21/98, eyz CN#800-6.0, added for Co-By Product Completions 11/04/99 MDS CN#EN800-6.0: Changed from 999.99 to 9999.99.
5	TOTAL_FRZN_STD	Signed Number(23,4)	DECIMAL(21,4) NOT NULL	Frozen Standard
6	EXTENDED_COST_TOT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Latest Cost Measure