CE_CREW_COST

(SQL Table)
Index Back

Actual Crew Cost

Actual Cost Enhancement 10/02

# 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 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 CE_CREW_RATE Signed Number(32,15) DECIMAL(30,15) NOT NULL Crew Rate
5 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
6 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
7 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

Default Value: I

8 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
9 CE_ENTRY_DATE DateTime(26) TIMESTAMP Entry Date/Time

Default Value: %DATETIME