PJB_BILL_RATE_OVRRDS

Details

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

Primary Key

Name	Columns
PJB_BILL_RATE_OVRRDS_H_PK	BILL_RATE_OVERRIDE_ID, MAJOR_VERSION

Columns

Name	Datatype	Length	Precision	Not-null	Comments
BILL_RATE_OVERRIDE_ID	NUMBER		18	Yes	Composite Primary Key with Major Version *****
MAJOR_VERSION	NUMBER		18	Yes	Major Version denotes version number of a record. *****
VERSION_TYPE	VARCHAR2	1		Yes	VERSION TYPE denotes if the record is Current or History or Amendment record. Valid values are 'C' for current, 'H' for history, and 'A' for Amendment. *****
RATE_OVERRIDE_TYPE_CODE	VARCHAR2	30		Yes	Type of the rate override, it can be EMP, JOB, NON LABOR *****
BILL_PLAN_ID	NUMBER		18		Denormalized bill plan id. *****
CONTRACT_LINE_ID	NUMBER		18		Contract line id. *****
ORGANIZATION_ID	NUMBER		18		Oraganization Id for schedules *****
RATE	NUMBER				The bill rate used to determine the item's revenue or bill amount. Revenue = bill rate * quantity
MARKUP_PERCENTAGE	NUMBER				Markup Percentage *****
RATE_CURRENCY_CODE	VARCHAR2	30			Currency of the bill rate override.
BILL_RATE_UNIT_CODE	VARCHAR2	30			The code of the bill rate unit. This value is always 'HOURS' because 'HOURS' is the only unit supported for labor items *****
DISCOUNT_PERCENTAGE	NUMBER				Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate
RATE_DISC_REASON_CODE	VARCHAR2	30			Reason code for dicount,discount override or rate override
START_DATE_ACTIVE	DATE			Yes	First effective date of the bill rate
END_DATE_ACTIVE	DATE				Last effective date of the bill rate
PERSON_ID	NUMBER		18		The identifier of the employee that will be billed according to the bill rate override
JOB_ID	NUMBER		18		The identifier of the job that will be billed according to the job bill rate override *****
NON_LABOR_RESOURCE_ID	NUMBER		18		The non-labor resource id that will be billed according to the non-labor bill rate override *****
NON_LABOR_RESOURCE_CODE	VARCHAR2	30			The non-labor resource that will be billed according to the non-labor bill rate override *****
EXPENDITURE_TYPE_ID	NUMBER		18		The expenditure type that will be billed according to the non-labor bill rate override. This column is also populated for a non-labor resource bill rate override *****
EXPENDITURE_TYPE_CODE	VARCHAR2	30			The expenditure type that will be billed according to the non-labor bill rate override. This column is also populated for a non-labor resource bill rate override *****
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.
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.
EXTERNAL_KEY1	VARCHAR2	150			External key that uniquely identifies a record.
EXTERNAL_KEY2	VARCHAR2	150			Additional attribute to qualify external key.

Indexes

Index	Uniqueness	Tablespace	Columns
PJB_BILL_RATE_OVRRDS_H_U1	Unique	Default	BILL_RATE_OVERRIDE_ID, MAJOR_VERSION