CAL_DETP_LOG (SQL Table)	Index Back
Calendar Deletion Log

CAL_DETP_LOG

(SQL Table)

Calendar Deletion Log

# 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

2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

4 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.

5 BEGIN_DT Date(10) DATE NOT NULL Begin Date

6 END_DT Date(10) DATE NOT NULL End Date

7 PERIOD_NAME Character(30) VARCHAR2(30) NOT NULL Period Name

8 PERIOD_ABBRV Character(3) VARCHAR2(3) NOT NULL Abbreviation

9 PD_ALLOC Number(19,15) DECIMAL(18,15) NOT NULL Period Allocation

10 PD_ALLOC_TOTAL Number(19,15) DECIMAL(18,15) NOT NULL Total Allocation Periods

11 ALLOC_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Allocation Update Switch
Default Value: N

12 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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
2	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID
3	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
4	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.
5	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
6	END_DT	Date(10)	DATE NOT NULL	End Date
7	PERIOD_NAME	Character(30)	VARCHAR2(30) NOT NULL	Period Name
8	PERIOD_ABBRV	Character(3)	VARCHAR2(3) NOT NULL	Abbreviation
9	PD_ALLOC	Number(19,15)	DECIMAL(18,15) NOT NULL	Period Allocation
10	PD_ALLOC_TOTAL	Number(19,15)	DECIMAL(18,15) NOT NULL	Total Allocation Periods
11	ALLOC_UPDATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Allocation Update Switch Default Value: N
12	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.