MULTI_SHIFT_YR (SQL Table)	Index Back
Multi-Shift Year

MULTI_SHIFT_YR

(SQL Table)

Multi-Shift Year

# 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 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

5 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

6 MULTI_SHIFT_NBR Number(1,0) SMALLINT NOT NULL This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.

#	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	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
5	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
6	MULTI_SHIFT_NBR	Number(1,0)	SMALLINT NOT NULL	This field is used to indicate the number of shifts operated within a fiscal year during a multi-shift operation.