BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUMGOP_NONVW
Default Value: 1
1=1
2=2
3=3
C=Compressed
N=Not Applicable
R=Rotating
Prompt Table: MG_SHIFTS_VW
MG_WORK_WK_DEFN(SQL Table) |
Index Back |
|---|---|
Five Day Work Week Definition07/23/98 TKI CN#MG800-5.0 Removed SHIFT field and replaced with MG_SHIFT; modified SQLEXEC call in MG_SHIFT.FieldEdit and replaced SHIFT with MG_SHIFT for database reconciliation project |
| # | 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 | MFG_SHIFT | Signed Number(3,0) | DECIMAL(2) NOT NULL |
MFG Shift
Default Value: 1 |
| 3 | MG_SHIFT | Number(2,0) | SMALLINT NOT NULL |
MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift.
07/23/98 TKI CN#MG800-5.0
Created to replace SHIFT for the database reconcilation project (8.0)
1=1 2=2 3=3 C=Compressed N=Not Applicable R=Rotating Prompt Table: MG_SHIFTS_VW |