PJC_CINT_RS_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: PJC

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PJC_CINT_RS_REVISIONS_PK	CINT_RS_REVISION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CINT_RS_REVISION_ID	NUMBER		18	Yes	The system-generated number which uniquely identifies the capitalized interest rate schedule revision *****
CINT_RATE_SCH_ID	NUMBER		18	Yes	The identifier of the capitalized interest rate schedule that the revision belongs to *****
RATE_SCH_REVISION	VARCHAR2	30		Yes	The implementation-defined name of the capitalized interest rate schedule revision *****
ORG_TREE_STRUCTURE_CODE	VARCHAR2	30		Yes	The default organization hierarchy structure used for capitalized interest rate schedule version *****
ORG_TREE_CODE	VARCHAR2	30		Yes	The default organization hierarchy used for capitalized interest rate schedule version *****
ORG_TREE_VERSION_ID	VARCHAR2	32		Yes	The hierarchy version for the capitalized interest rate schedule schedule version. *****
START_ORGANIZATION_ID	NUMBER		18	Yes	The highest organization hierarchy used for the capitalized interest rate schedule version. *****
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_FLAG	VARCHAR2	1		Yes	Flag indicates whether the burden schedule revision is compiled *****
COMPILED_DATE	DATE				The date when the burden schedule revision was compiled *****
READY_TO_COMPILE_FLAG	VARCHAR2	1		Yes	Flag indicates if the burden schedule is ready for compilation *****
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.
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.
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
PJC_CINT_RS_REVISIONS	pjc_cint_rate_sch_b	CINT_RATE_SCH_ID
pjc_alloc_txn_details	pjc_cint_rs_revisions	IND_RATE_SCH_REVISION_ID
pjc_cint_compiled_mults	pjc_cint_rs_revisions	CINT_RS_REVISION_ID
pjc_cint_rate_multplrs	pjc_cint_rs_revisions	CINT_RS_REVISION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJC_CINT_RS_REVISIONS_U1	Unique	Default	CINT_RS_REVISION_ID
PJC_CINT_RS_REVISIONS_U2	Unique	Default	CINT_RATE_SCH_ID, RATE_SCH_REVISION