PJC_CINT_RATE_INFO_ALL

Stores information used to determine how capitalized interest is calculated for each operating unit

Details

• Schema: FUSION

• Object owner: PJC

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
PJC_CINT_RATE_INFO_ALL_PK	RATE_INFO_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RATE_INFO_ID	NUMBER		18	Yes	The system-generated number which uniquely identifies the capitalized interest rate detail information.
RATE_NAME_ID	NUMBER		18	Yes	The identifier of the capitalized interest rate name that the detail information belongs to.
ORG_ID	NUMBER		18	Yes	Indicates the identifier of the business unit associated to the row.
EXP_ORG_SOURCE	VARCHAR2	30		Yes	The source of the expenditure organization to be used on capitalized interest transactions
THRESHOLD_AMT_TYPE	VARCHAR2	30			The amount type used for defining thresholds
FIN_PLAN_TYPE_ID	NUMBER		18		Identifies the financial plan type on which threshold amounts are based
PROJ_AMT_THRESHOLD	NUMBER				Project amount threshold
TASK_AMT_THRESHOLD	NUMBER				Task amount threshold
PROJ_DURATION_THRESHOLD	NUMBER				Project duration threshold
TASK_DURATION_THRESHOLD	NUMBER				Task duration threshold
CURR_PERIOD_CONVENTION	VARCHAR2	30		Yes	Determines how much of the current periods CIP amount is included in the capitalized interest calculation
INTEREST_CALCULATION_METHOD	VARCHAR2	30		Yes	Indicates whether simple or compound interest is used during capitalized interest calculation
PERIOD_RATE_CODE	VARCHAR2	30		Yes	Determine how interest amounts are prorated across General Ledger periods
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
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.
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_RATE_INFO_ALL	pjc_cint_rate_names	RATE_NAME_ID
pjc_cint_exp_typ_ecl_all	pjc_cint_rate_info_all	RATE_INFO_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PJC_CINT_RATE_INFO_ALL_U1	Unique	Default	RATE_INFO_ID
PJC_CINT_RATE_INFO_ALL_U2	Unique	Default	RATE_NAME_ID, ORG_ID