PJS_PROG_PERIODS

Details

Schema: FUSION
Object owner: PJS
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
PJS_PROG_PERIODS_MAP_PK	GL_PERIOD_SET_NAME, GL_PERIOD_NAME

Columns

Name	Datatype	Length	Precision	Not-null	Comments
GL_CALENDAR_ID	NUMBER		18	Yes	Unique identifier of the ledger calendar.
GL_PERIOD_SET_NAME	VARCHAR2	15		Yes	Name of the accounting calendar.
GL_PERIOD_TYPE	VARCHAR2	15		Yes	Accounting period type. Examples are Weekly, Monthly, Quarterly.
GL_PERIOD_NAME	VARCHAR2	15		Yes	Accounting calendar period contained in a partition.
GL_PERIOD_NUM	NUMBER		18	Yes	Unique period number within accounting calendar year.
GL_PERIOD_START_DATE	DATE			Yes	Date when the accounting period begins.
GL_PERIOD_END_DATE	DATE			Yes	Date when the accounting period ends.
GL_QUARTER_START_DATE	DATE			Yes	Date when the quarter containing this accounting period starts.
GL_QUARTER_NUM	NUMBER		18	Yes	Quarter number of accounting period.
GL_YEAR_START_DATE	DATE			Yes	Date when the year containing this accounting period starts.
GL_YEAR_NUM	NUMBER		18	Yes	Year number of accounting period.
ENTERPRISE_CALENDAR_ID	NUMBER		18	Yes	Unique identifier for the accounting calendar. The calendar is used to define the periods for project and program performance reporting.
ENTERPRISE_PERIOD_SET_NAME	VARCHAR2	15		Yes	Name of the accounting calendar used for program performancereporting.
ENTERPRISE_PERIOD_TYPE	VARCHAR2	15		Yes	Type of the accounting calender used for the program performance reporting.
ENTERPRISE_PERIOD_NAME	VARCHAR2	15		Yes	Period name of accounting calender used for the program performance reporting.
ENTERPRISE_PERIOD_NUM	NUMBER		18	Yes	Unique period number within accounting calendar year used for the program performance reporting.
ENTERPRISE_PERIOD_START_DATE	DATE			Yes	Date when the accounting period begins.
ENTERPRISE_PERIOD_END_DATE	DATE			Yes	Date when the accounting period ends.
ENTERPRISE_QUARTER_START_DATE	DATE			Yes	Date when the accounting period quarter starts.
ENTERPRISE_QUARTER_NUM	NUMBER		18	Yes	Quarter number of accounting period.
ENTERPRISE_YEAR_START_DATE	DATE			Yes	Date when the accounting period year starts.
ENTERPRISE_YEAR_NUM	NUMBER		18	Yes	Year number of accounting period.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
ADDL_ATTRIBUTE1	VARCHAR2	150			Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE2	VARCHAR2	150			Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE3	VARCHAR2	150			Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE4	VARCHAR2	150			Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE5	VARCHAR2	150			Column supporting alphanumeric characters reserved for internal use.

Indexes

Index	Uniqueness	Tablespace	Columns
PJS_PROG_PERIODS_MAP_N1	Non Unique	Default	GL_CALENDAR_ID, GL_PERIOD_NAME, GL_PERIOD_START_DATE
PJS_PROG_PERIODS_MAP_N2	Non Unique	Default	ENTERPRISE_PERIOD_NAME
PJS_PROG_PERIODS_MAP_U1	Unique	Default	GL_PERIOD_SET_NAME, GL_PERIOD_NAME
PJS_PROG_PERIODS_MAP_U2	Unique	Default	GL_PERIOD_SET_NAME, GL_PERIOD_TYPE, GL_YEAR_NUM, GL_PERIOD_NUM