PeopleSoft 9
Asset Management

Table Name CAL_DETP_TBL

Table Description
CAL_DETP_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes Yes
CALENDAR_ID char(2) Yes Yes
FISCAL_YEAR smallint Yes No
ACCOUNTING_PERIOD smallint Yes No
BEGIN_DT PSDATE No No
END_DT PSDATE No No
PERIOD_NAME char(30) No No
PERIOD_ABBRV char(3) No No
PD_ALLOC decimal(18,15) No No
PD_ALLOC_TOTAL decimal(18,15) No No
ALLOC_UPDATE_SW char(1) No No
Index
Name Type Unique Member
PS_CAL_DETP_TBL PK Yes
PSACAL_DETP_TBL IE1 No
PSBCAL_DETP_TBL IE2 No
PSCCAL_DETP_TBL IE3 No
Member(s) of "PS_CAL_DETP_TBL" Index
SETID
CALENDAR_ID
FISCAL_YEAR
ACCOUNTING_PERIOD
Member(s) of "PSACAL_DETP_TBL" Index
BEGIN_DT
END_DT
Member(s) of "PSBCAL_DETP_TBL" Index
FISCAL_YEAR
ACCOUNTING_PERIOD
Member(s) of "PSCCAL_DETP_TBL" Index
SETID
CALENDAR_ID
BEGIN_DT
END_DT
FISCAL_YEAR
ACCOUNTING_PERIOD

Published December 16, 2006