PJF_IRS_REVISIONS

PA_IND_RATE_SCH_REVISIONS stores revisions of burden schedules with different effective dates. Each revision is a group of burden rates that are effective between the start date and end date of the revision. . .

Details

• Schema: FUSION

• Object owner: PJF

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
PJF_IRS_REVISIONS_PK	IND_RATE_SCH_REVISION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
IND_RATE_SCH_REVISION_ID	NUMBER		18	Yes	The system-generated number which uniquely identifies the burden schedule revision
TREE_CODE	VARCHAR2	30			TREE_CODE
TREE_VERSION_ID	VARCHAR2	32			TREE_VERSION_ID
IND_RATE_SCH_ID	NUMBER		18	Yes	The identifier of the burden schedule that the revision belongs to
IND_RATE_SCH_REVISION	VARCHAR2	30		Yes	The implementation-defined name of the burden schedule revision
IND_RATE_SCH_REVISION_TYPE	VARCHAR2	1		Yes	The type of the burden schedule revision
COMPILED_FLAG	VARCHAR2	1		Yes	Flag indicates whether the burden schedule revision is compiled
IND_STRUCTURE_NAME	VARCHAR2	30		Yes	The name of the burden structure that the burden schedule uses for burdening *****
START_DATE_ACTIVE	DATE			Yes	First effective date of the burden schedule revision
END_DATE_ACTIVE	DATE				Last effective date of the burden schedule revision
COMPILED_DATE	DATE				The date when the burden schedule revision was compiled
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
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_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
READY_TO_COMPILE_FLAG	VARCHAR2	1		Yes	Flag indicates if the burden schedule is ready for compilation
ACTUAL_SCH_REVISION_ID	NUMBER		18		The identifier of the actual burden schedule revision which applied on the provisional burden schedule revision
START_ORGANIZATION_ID	NUMBER		18	Yes	Identifier of the highest organization used for the burden hierarchy.
TREE_STRUCTURE_CODE	VARCHAR2	30			TREE_STRUCTURE_CODE
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
PJF_IRS_REVISIONS	pjf_ind_rate_sch_b	IND_RATE_SCH_ID
PJF_IRS_REVISIONS	pjf_cost_plus_structures	IND_STRUCTURE_NAME
PJF_IRS_REVISIONS	pjf_irs_revisions	ACTUAL_SCH_REVISION_ID
pjf_ind_cost_multipliers	pjf_irs_revisions	IND_RATE_SCH_REVISION_ID
pjf_irs_revisions	pjf_irs_revisions	ACTUAL_SCH_REVISION_ID
pjf_ind_compiled_sets	pjf_irs_revisions	IND_RATE_SCH_REVISION_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
PJF_IRS_REVISIONS_N1	Non Unique	Default	IND_RATE_SCH_ID	Obsolete
PJF_IRS_REVISIONS_N2	Non Unique	Default	IND_STRUCTURE_NAME
PJF_IRS_REVISIONS_N3	Non Unique	Default	ACTUAL_SCH_REVISION_ID
PJF_IRS_REVISIONS_N4	Non Unique	Default	IND_RATE_SCH_REVISION, IND_RATE_SCH_REVISION_TYPE
PJF_IRS_REVISIONS_U1	Unique	Default	IND_RATE_SCH_REVISION_ID
PJF_IRS_REVISIONS_U2	Unique	Default	IND_RATE_SCH_ID, IND_RATE_SCH_REVISION, IND_RATE_SCH_REVISION_TYPE