PeopleSoft 9
Asset Management

Table Name MULTI_SHIFT_YR

Table Description
MULTI_SHIFT_YR
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
MULTI_SHIFT_CODE char(6) Yes Yes
EFFDT PSDATE Yes No
FISCAL_YEAR smallint Yes No
ACCOUNTING_PERIOD smallint Yes No
MULTI_SHIFT_NBR smallint No No
Index
Name Type Unique Member
PS_MULTI_SHIFT_YR PK Yes
Member(s) of "PS_MULTI_SHIFT_YR" Index
SETID
MULTI_SHIFT_CODE
EFFDT
FISCAL_YEAR
ACCOUNTING_PERIOD

Published December 16, 2006