MULTI_SHIFT_FAC (SQL Table)	Index Back
MULTI SHIFT FACTOR

MULTI_SHIFT_FAC

(SQL Table)

MULTI SHIFT FACTOR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 MULTI_SHIFT_CODE Character(6) VARCHAR2(6) NOT NULL Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 MULTI_SHFT2_FACTOR Signed Number(7,2) DECIMAL(5,2) NOT NULL 2 shifts factor - This field is used to indicate the multi-shift factor for a 2 shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.

5 MULTI_SHFT3_FACTOR Signed Number(7,2) DECIMAL(5,2) NOT NULL 3 shifts factor - This field is used to indicate the multi-shift factor for a 3 shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.

6 MULTI_SHFT4_FACTOR Signed Number(7,2) DECIMAL(5,2) NOT NULL 4 shifts factor - This field is used to indicate the multi-shift factor for a 4 shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	MULTI_SHIFT_CODE	Character(6)	VARCHAR2(6) NOT NULL	Multi_Shift Code is used to assign and specify the Multi_Shift factor. A Multi_Shift factor is used to indicate the % of increase of annual depreciation during a multi_shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	MULTI_SHFT2_FACTOR	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	2 shifts factor - This field is used to indicate the multi-shift factor for a 2 shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.
5	MULTI_SHFT3_FACTOR	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	3 shifts factor - This field is used to indicate the multi-shift factor for a 3 shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.
6	MULTI_SHFT4_FACTOR	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	4 shifts factor - This field is used to indicate the multi-shift factor for a 4 shift operation. For example a shift factor of 50% means there will be a 50% increase of the annual depreciation.