My Projects Table Descriptions hand book (I have big hands) part1

Projects - PA_CUST_REV_DIST_LINES_ALL	Information about expenditure item revenue distribution
Column Name	Descritpion
EXPENDITURE_ITEM_ID	The identifier of the expenditure item that is revenue distributed by the distribution line
BILL_AMOUNT	The amount to be billed for the distribution line in invoice processing currency.
FUNCTION_CODE	The AutoAccounting function under which the distribution line was revenue distributed. This value is used to distinguish borrowed and lent transaction lines from revenue transaction lines
FUNCTION_TRANSACTION_CODE	The AutoAccounting function transaction under which the distribution line was revenue distributed
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
BATCH_NAME	The reference to the GL je line in which the revenue was included when posted to GL. This value is a concatenation of ccid, draft revenue gl date, and transfer request id separated by hyphens. Joins to GL_JE_LINES.REFERENCE1
ADDITIONAL_REVENUE_FLAG	Flag that indicates if the distribution line is adding additional revenue for an item so that the item will accrue its full potential revenue. This distribution line is used to increment revenue and will never be billed.
INVOICE_ELIGIBLE_FLAG	Flag to mark whether the distribution line is eligible to be included on an invoice because it can be funded with available funding. The Generate Draft Invoices program temporarily sets the flag while processing a project's invoice
LINE_NUM	The sequential number that identifies the revenue distribution line for the expenditure item
DRAFT_INVOICE_NUM	The draft invoice number on which the distribution line is invoiced
DRAFT_INVOICE_ITEM_LINE_NUM	The draft invoice item line number on which the distribution line is invoiced
REVERSED_FLAG	Flag that indicates if the distribution line is reversed by another distribution line
LINE_NUM_REVERSED	The distribution line number for the expenditure item that is reversed by this distribution line
REV_IND_COMPILED_SET_ID	The identifier of the compiled set which is used to calculate the burden cost for revenue
INV_IND_COMPILED_SET_ID	The identifier of the compiled set which is used to calculate the burden cost for invoicing
RAW_COST	raw_cost column will have the value of burden_cost for BURDEN TRANSACTIONS
ORG_ID	Operating unit identifier for multi-organization installations
OUTPUT_VAT_TAX_ID	Identifier for default output tax code
OUTPUT_TAX_EXEMPT_FLAG	Standard, Exempt, or required Allows the user to use Standard Exemption rules, force an exemption or require tax to a normally exempt invoice This is defaulted based on user setup
CREATION_DATE	Standard Who Column
OUTPUT_TAX_EXEMPT_REASON_CODE	Tax Exempt Reason for item lines that have tax_exempt_flag set to (E-exempt)
OUTPUT_TAX_EXEMPT_NUMBER	Exemption Certificate Number for item lines that have tax_exempt_flag set to (E-exempt)
PRC_GENERATED_FLAG	For future use
BILL_TRANS_CURRENCY_CODE	Bill transaction currency code for the expenditure item.
BILL_TRANS_AMOUNT	The billing amount of the item in the bill transaction currency.
BILL_TRANS_BILL_AMOUNT	Base bill amount in the bill transaction currency.
BILL_RATE	The bill rate for the expenditure item in bill transaction currency. This column is not populated if (1) a markup percentage or labor multiplier was used to calculate TM revenue or (2) revenue is accrued under a Cost/Cost or Cost/Event dist
REVPROC_CURRENCY_CODE	Revenue processing currency code
REVPROC_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to revenue processing currency during revenue generation. Currently, the project functional currency is the revenue processing currency.
REVPROC_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to the revenue processing currency if Fixed Date rate date type is used during revenue generation. Currently, the project functional currency is the revenue processing
REVPROC_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to revenue processing during revenue generation. Currently, the project functional currency is the revenue processing currency.
CREATED_BY	Standard Who Column
INVPROC_CURRENCY_CODE	Invoice processing currency.
INVPROC_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency during revenue generation
INVPROC_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during revenue generation
INVPROC_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functional if User exchange rate type is used during revenue generation.
PROJECT_CURRENCY_CODE	Project currency code.
PROJECT_REVENUE_AMOUNT	Revenue Amount in the project currency.
PROJECT_REV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency during revenue generation
PROJECT_REV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used during revenue generation
PROJECT_REV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency if User exchange rate type used during revenue generation
PROJECT_BILL_AMOUNT	Bill amount in the project currency. This is calculated by applying the conversion rules set up for project currency during invoice generation
PROJECT_ID	The identifier of the project for which the revenue distribution line is generated. This project is the project to which the expenditure item was charged
PROJECT_INV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency during invoice generation
PROJECT_INV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used during invoice generation
PROJECT_INV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency during invoice generation
PROJFUNC_CURRENCY_CODE	Project functional currency code.
PROJFUNC_REVENUE_AMOUNT	Revenue amount in the project functional currency.
PROJFUNC_REV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency during revenue generation.
PROJFUNC_REV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during revenue generation.
PROJFUNC_REV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functional currency during revenue generation
PROJFUNC_BILL_AMOUNT	Bill Amount in the project functional currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation.
PROJFUNC_INV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency during invoice generation
DRAFT_REVENUE_NUM	The draft revenue number for which the revenue distribution line is generated
PROJFUNC_INV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during invoice generation
PROJFUNC_INV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functional currency during invoice generation
FUNDING_CURRENCY_CODE	Funding currency code.
FUNDING_REVENUE_AMOUNT	Revenue amount in the funding currency
FUNDING_REV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to funding currency during revenue generation.
FUNDING_REV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used during revenue generation.
FUNDING_REV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to funding currency during revenue generation
FUNDING_BILL_AMOUNT	Bill amount in funding currency.
FUNDING_INV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency during invoice generation
FUNDING_INV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used during invoice generation
DRAFT_REVENUE_ITEM_LINE_NUM	The draft revenue item line number under which the revenue distribution line is generated
FUNDING_INV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency during invoice generation.
LABOR_MULTIPLIER	Audit column for rate derivation. The labor multiplier is used to derive the raw revenue.
DISCOUNT_PERCENTAGE	Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate.
AMOUNT_CALCULATION_CODE	Audit column for rate derivation. Valid values are Indirect (I), Overrides (O), Extension (E), and Bill Rates (B).
BILL_MARKUP_PERCENTAGE	Audit column for bill rate derivation. The markup percentage used in deriving the bill rate is based on a markup in the bill rate schedule.
RATE_SOURCE_ID	Audit column for bill rate derivation. It stores the rate schedule ID if a bill rate schedule was used, the override ID if an override was used.
INV_GEN_REJECTION_CODE	Invoice generation rejection code
RETN_DRAFT_INVOICE_NUM	Project invoice number. This will be used to drilldown the retention line from invoice review screen.
RETN_DRAFT_INVOICE_LINE_NUM	Project invoice retention line number. This will be used to drilldown the retention line from invoice review screen.
RETAINED_AMOUNT	Retained amount. This amount is in the invoice processing currency.
RETENTION_RULE_ID	The identifier of the retention rule
RATE_DISC_REASON_CODE	Reason code for dicount,discount override or rate override
OUTPUT_TAX_CLASSIFICATION_CODE	eTax change
AMOUNT	The Revenue amount of the expenditure item to be charged to the GL account in the revenue processing currency. The amount is stored as debit, so the lent transaction amounts and adjusment amounts are negative.
REVTRANS_AMOUNT	Transaction amount in revenue currency
REVTRANS_CURRENCY_CODE	Revenue transaction currency code
REVPROC_REVTRANS_RATE_TYPE	Exchange rate type to be used for conversion between revenue processing currency and revenue transaction currency
REVPROC_REVTRANS_RATE_DATE	Exchange rate date to be used for conversion between revenue processing currency and revenue transaction currenc
REVPROC_REVTRANS_EX_RATE	Exchange rate to be used for conversion between revenue processing currency and revenue transaction currenc
CODE_COMBINATION_ID	The identifier of the gl account to which the revenue is charged

Projects - PA_COST_DISTRIBUTION_LINES_ALL	Information about expenditure item cost distribution
Column Name	Descritpion
EXPENDITURE_ITEM_ID	The identifier of the expenditure item that is cost distributed by the distribution line
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
PA_DATE	Date used to determine the correct project accounting period in the provider operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date
DR_CODE_COMBINATION_ID	The identifier of the GL account to which the cost is charged
GL_DATE	Date used to determine the correct general ledger accounting period in the provider operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date. For supplier in
TRANSFERRED_DATE	The date the distribution line was transferred to another application
TRANSFER_REJECTION_REASON	The reason why the distribution line was rejected by the PA Cost Transfer program or rejected by the other application's interface program
BATCH_NAME	The reference to a batch of lines transferred together. For expense reports, this is an expenditure batch. For cost transferred to GL, this is a concatenation of liability ccid, gl date, and transfer request id separated by hyphens.
ACCUMULATED_FLAG	Flag indicating if distribution line cost is included in the accumulator tables. Set to 'N' initially, 'Y' when the line is accumulated. Obsolete as of 4.0 with the new project summary amounts. Replaced by RESOURCE_ACCUMULATED_FLAG.
LINE_NUM	The sequential number that identifies the cost distribution line for an expenditure item
REVERSED_FLAG	Flag that indicates if the distribution line is reversed by another distribution line
LINE_NUM_REVERSED	The distribution line number that is reversed by this distribution line
SYSTEM_REFERENCE1	The reference to the record in another application when the line is transferred. For supplier invoices, this holds AP_INVOICES.VENDOR_ID. This is not used for other adjustment lines.
SYSTEM_REFERENCE2	The reference to the record in another application when the line is transferred For supplier invoices and expense reports, this holds the AP_INVOICESINVOICE_ID Not used for labor and usages
SYSTEM_REFERENCE3	The reference to the record in another application when the line related to supplier invoice or expense report is transferred. It holds AP_INVOICE_DISTRIBUTIONS.DISTRIBUTION_LINE_NUMBER.
CR_CODE_COMBINATION_ID	The identifier of the GL liability account
IND_COMPILED_SET_ID	The identifier of the compiled set which is used to calculate the burden cost
LINE_TYPE	The type of the cost distribution line
BURDENED_COST	Amount of the burdened cost in project currency
RESOURCE_ACCUMULATED_FLAG	Flag to indicate whether this cost distribution line is resource accumulated. The cost distribution line may be accumulated in the current reporting period or future periods. In both cases the resource accum flag will be = 'Y'
CREATION_DATE	Standard Who Column
FUNCTION_TRANSACTION_CODE	This is a PA 3.0 column
ORG_ID	Operating unit identifier for multi-organization installations
CODE_COMBINATION_ID	Obsolete as of Version 3.1
BURDEN_SUM_SOURCE_RUN_ID	This will identify group of Cost Distribution Lines that were summarized to create summarized burden component expenditure items(EI). The same run_id will be populated in EI table to identify all EI's created during a run.
BURDEN_SUM_REJECTION_CODE	Burden component summarization rejection code
DENOM_CURRENCY_CODE	Transaction Currency code of the transaction
DENOM_RAW_COST	The raw cost in transaction currency
DENOM_BURDENED_COST	The amount of the burdened cost in transaction currency It is only populated for raw cost distribution lines
ACCT_CURRENCY_CODE	Functional Currency Code
ACCT_RATE_DATE	Conversion rate date used to convert raw cost from transaction currency to functional currency
CREATED_BY	Standard Who Column
ACCT_RATE_TYPE	Conversion rate type used to convert raw cost from transaction currency to functional currency
ACCT_EXCHANGE_RATE	Conversion rate used to convert raw cost from transaction currency to functional currency
ACCT_RAW_COST	The amount in functional currency to be charged to the gl account for the expenditure item The amount is stored as a debit, so the burden credit amounts and adjustment amounts are negative
ACCT_BURDENED_COST	Burdened cost in functional currency
PROJECT_CURRENCY_CODE	Project currency code of the transaction
PROJECT_RATE_DATE	Conversion rate date used to convert raw cost from transaction currency to project currency
PROJECT_RATE_TYPE	Conversion rate date used to convert raw cost from transaction currency to project currency
PROJECT_EXCHANGE_RATE	Conversion rate date used to convert raw cost from transaction currency to project currency
PROJECT_ID	Identifier of the project
TASK_ID	Identifier of the task
PRC_GENERATED_FLAG	For future Use
RECVR_PA_DATE	Date used to determine the correct project accounting period in the receiver operating unit. The PA date is determined by the Distribution programs from the open or future PA period on or after the transaction date
RECVR_GL_DATE	Date used to determine the correct general ledgert accounting period in the receiver operating unit. The GL date is determined by the Distribution programs from the open or future GL period on or after the transaction date
TRANSFER_STATUS_CODE	The status of the distribution line as the cost information is transferred to another application
UTIL_SUMMARIZED_FLAG	Flag to indicate the summarization status of the line for utilization purposes. Values a re: Y = Summarized N = To be Summarized X = Never Summarized
LIQUIDATE_ENCUM_FLAG	This flag indicates if the encumbrance liquidation is required for the cost distribution line.
ENCUMBRANCE_BATCH_NAME	The batch name used which creating encumbrance liquidation.
ENCUMBRANCE_TYPE_ID	Commitment encumbrance type identifier used during processing.
ENCUM_TRANSFER_REJ_REASON	Reason why the commitment encumbrance liquidation entries was rejected by PA cost transfer program
BUDGET_CCID	The account of the budget line to which the transaction is mapped.
ENCUMBRANCE_AMOUNT	The amount encumbered when the encumbrance liquidation is created.
PROJFUNC_COST_EXCHANGE_RATE	Exchange rate used to convert costs from the transaction currency to the project functional currency.
PROJECT_RAW_COST	Raw cost in project currency.
PROJECT_BURDENED_COST	Burdened cost in project currency.
WORK_TYPE_ID	Identifier for a work type assigned to the transaction.
GL_PERIOD_NAME	The GL period in which the transaction is posted.
RECVR_GL_PERIOD_NAME	The GL period in which the transaction is posted on the receiving ledger.
PA_PERIOD_NAME	The PA period in which the transaction is posted.
PROJFUNC_COST_RATE_TYPE	Rate type used to convert costs from the transaction currency to the project functional currency.
PROJFUNC_COST_RATE_DATE	Rate date used to convert costs from the transaction currency to the project functional currency.
RECVR_PA_PERIOD_NAME	The PA period in which the transaction is posted on the receiving ledger.
PROJFUNC_CURRENCY_CODE	Project functional currency code.
SYSTEM_REFERENCE4	The reference to the record in another application when the line related to supplier invoice or expense report is transferred. It holds AP_INVOICE_PAYMENTS_ALL. INVOICE_PAYMENT_ID
PJI_SUMMARIZED_FLAG	Indicates whether the record has been summarized by Project Intelligence
AMOUNT	Amount in project currency Derrived by converting raw cost in transaction currency to project currency
ORG_LABOR_SCH_RULE_ID	Identifier for org schedule assignment
COST_RATE_SCH_ID	The identifier of the cost rate schedule used during costing.
DENOM_BURDENED_CHANGE	Change in burdened cost since last time distribution lines were created. Stored in transaction currency.
PROJECT_BURDENED_CHANGE	Change in burdened cost since last time the distribution lines were created. Stored in project currency.
PROJFUNC_BURDENED_CHANGE	Change in burdened cost since last time distribution lines were created. Stored in project functional currency.
ACCT_BURDENED_CHANGE	Change in burdened cost since last time distribution lines were created. Stored in functional currency.
PARENT_LINE_NUM	Line Number for the raw cost distribution line. Valid for I line types only.
PREV_IND_COMPILED_SET_ID	Identifier of the compiled set previously used to calculate the burden cost.
SI_ASSETS_ADDITION_FLAG	This column indicates the status of the cost distribution line in relation to Oracle Assets. This column only applies to supplier cost expenditure items. Valid values are as follows:Y - The distribution line is interfaced to Oracle Assets.
SYSTEM_REFERENCE5	This column refers to a record in another application. When the cost distribution line is related to Oracle Payables transactions, it holds AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_DISTRIBUTION_ID. When the cost distribution line is related to
ACCT_EVENT_ID	Identifier of Accounting Event
ACCT_SOURCE_CODE	Code used to identify accounting transactions, which are not migrated to SLA
BUDGET_LINE_ID	Identifier of the budget line used for encumbrance accounting
BUDGET_VERSION_ID	Identifier of the budget version used for encumbrance accounting
QUANTITY	The number of units that are costed in the distribution line cost. The quantity is set from the expenditure item quantity when the distribution line is created and is used for populating the quantities in the accumulation tables
BILLABLE_FLAG	Flag that indicates whether the cost amount is billable. The flag is set from the expenditure item billable flag when the distribution line is created and is used for determining billable/non-billable costs in the accumulation tables
REQUEST_ID	Standard Who Column

Projects - PA_COST_DIST_OVERRIDES	Configurations used to override the expenditure organization used by AutoAccounting for projects
Column Name	Descritpion
COST_DISTRIBUTION_OVERRIDE_ID	The system-generated number that uniquely identifies the cost distribution override
PERSON_ID	The identifier of the employee for which costs and revenue are overridden
EXPENDITURE_CATEGORY	The expenditure category for which costs and revenue are overridden
OVERRIDE_FROM_ORGANIZATION_ID	The identifier of the organization for which costs and revenue are overridden
END_DATE_ACTIVE	Last effective date of the override
PROJECT_ID	The identifier of the project that is configured according to the cost distribution override
OVERRIDE_TO_ORGANIZATION_ID	The identifier of the organization to which costs and revenue are overridden
START_DATE_ACTIVE	First effective date of the override
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_COMPENSATION_DETAILS_ALL	Information about hourly employee cost rates and assigned compensation rules
Column Name	Descritpion
PERSON_ID	The identifier of the employee for which the compensation detail is entered
HOURLY_COST_RATE	The hourly rate for the employee used in labor costing
COMPENSATION_RULE_SET	The compensation rule which indicates how the employee is compensated, particularly for overtime hours
END_DATE_ACTIVE	Last effective date of the compensation detail
START_DATE_ACTIVE	First effective date of the compensation detail
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
CREATION_DATE	Standard Who Column
ATTRIBUTE10	Descriptive flexfield segment
ORG_ID	Operating unit identifier for multi-organization installations
OVERRIDE_TYPE	Type of override
CREATED_BY	Standard Who Column
RATE_SCHEDULE_ID	The cost rate schedule that defines cost rates for the selected employee.
COST_RATE_CURRENCY_CODE	Currency code for the cost rate
LAST_UPDATE_LOGIN	Standard Who Column
ACCT_RATE_DATE_CODE	Functional Rate Date override for currency conversion.
ACCT_RATE_TYPE	Functional Rate Type override for currency conversion.
ACCT_EXCHANGE_RATE	Exchange rate used for currency conversion

Projects - PA_COMPENSATION_RULE_SETS	Implementation-defined classifications of employee compensation (also referred to as pay types)
Column Name	Descritpion
COMPENSATION_RULE_SET	Implementation-defined name that uniquely identifies the compensation rule
ALLOCATED_OVERTIME_EXP_TYPE	The overtime expenditure type used to create overtime expenditure items in the Overtime Calculation program for employees assigned this compensation rule
END_DATE_ACTIVE	Last effective date of the compensation rule
PROJECT_ID	The identifier of the overtime project that defaults upon manual entry of overtime labor items for employees assigned to the compensation rule
TASK_ID	The identifier of the task that defaults upon manual entry of overtime labor items for employees assigned to the compensation rule
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
CREATION_DATE	Standard Who Column
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
CREATED_BY	Standard Who Column
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
COSTING_METHOD	Indicates whether labor costs are calculated by applying cost rates or whether labor costs are calculated by the labor costing extension.
LAST_UPDATE_LOGIN	Standard Who Column
START_DATE_ACTIVE	First effective date of the compensation rule

Projects - PA_BILL_RATES_ALL	Information about bill rates and markups of standard bill rate schedules
Column Name	Descritpion
BILL_RATE_ORGANIZATION_ID	The identifier of the organization that owns the standard bill rate schedule to which the bill rate belongs
STD_BILL_RATE_SCHEDULE	The standard bill rate schedule to which the bill rate belongs
PERSON_ID	The identifier of the employee for which the bill rate is entered
JOB_ID	The identifier of the job for which the bill rate is entered
LAST_UPDATE_DATE	Standard Who Column
EXPENDITURE_TYPE	The non-labor expenditure type for which the bill rate is entered
LAST_UPDATED_BY	Standard Who Column
NON_LABOR_RESOURCE	The non-labor resource for which the bill rate is entered. The expenditure type is also populated if the non-labor resource is specified
RATE	The bill rate used to determine an item's bill or revenue amount. Revenue = (bill rate * quantity)
BILL_RATE_UNIT	The code of the bill rate unit. Holds the unit of the expenditure type. This column is populated only if a bill rate is defined; it is not used with markup percentages.
CREATION_DATE	Standard Who Column
MARKUP_PERCENTAGE	The markup percentage over raw cost used to determine an item's revenue or bill amount. Revenue = raw cost * (1 + (markup/100))
END_DATE_ACTIVE	Last effective date of the bill rate
ORG_ID	Operating unit identifier for multi-organization installations
CREATED_BY	Standard Who Column
BILL_RATE_SCH_ID	The identifier of the Bill Rate Schedule
JOB_GROUP_ID	Identifies the Jobs which can be used in this schedule for setting up the bill rates.
LAST_UPDATE_LOGIN	Standard Who Column
RATE_CURRENCY_CODE	Rate Currency Code
START_DATE_ACTIVE	First effective date of the bill rate
RESOURCE_CLASS_CODE	Identifies the resouce class
RES_CLASS_ORGANIZATION_ID	Identifies the planning resource organization ID

Projects - PA_CLASS_CODES	Implementation-defined values within class categories that can be used to classify projects
Column Name	Descritpion
CLASS_CATEGORY	The class category to which the class code belongs
DESCRIPTION	Explanation of the class code
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
CLASS_CODE	Implementation-defined name that uniquely identifies the code within the class category
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ADW_NOTIFY_FLAG	The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
CLASS_CODE_ID	ID column for table. Generated sequentially.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
START_DATE_ACTIVE	First effective date of the class code
END_DATE_ACTIVE	Last effective date of the class code

Projects - PA_CLASS_CATEGORIES	Implementation-defined categories for classifying projects
Column Name	Descritpion
CLASS_CATEGORY	Implementation-defined name that uniquely identifies the category
START_DATE_ACTIVE	First effective date of the class category
END_DATE_ACTIVE	Last effective date of the class category
DESCRIPTION	Explanation of the class category
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ADW_NOTIFY_FLAG	The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
CREATION_DATE	Standard Who Column
OBJECT_TYPE	The object type to which the category is associated
CREATED_BY	Standard Who Column
ALLOW_PERCENT_FLAG	Flag that indicates whether users can enter percentages for the category
LAST_UPDATE_LOGIN	Standard Who Column
TOTAL_100_PERCENT_FLAG	Flag that indicates whether the percentages for the category must sum to 100
MANDATORY_FLAG	Flag that indicates whether a user must enter a code for the class category before a project can be authorized for revenue distribution
ALL_TYPES_VALID_FLAG	Flag that indicates whether the category is valid for all categories
AUTOACCOUNTING_FLAG	Flag that indicates whether the class code of the class category may be used as a parameter for AutoAccounting. Only one class category can be defined for use with AutoAccounting
INCLUDE_IN_PJI_FLAG	Indicate whether the category is included in Project Intelligence.
CLASS_CATEGORY_ID	ID column for table. Generated sequentially.
GPD_PERIOD_SET_NAME
PICK_ONE_CODE_ONLY_FLAG	Flag that indicates whether a user can pick only one code for the class category for a project. If autoaccounting_flag = 'Y' for the category, this flag is automatically set to 'Y'
GPD_PERIOD_NAME

Projects - PA_CUST_EVENT_RDL_ALL	Information about event revenue distribution
Column Name	Descritpion
TASK_ID	The identifier of the task that the event is assigned to
CODE_COMBINATION_ID	The identifier of the gl account to which the revenue is charged
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
DRAFT_INVOICE_NUM	The draft invoice number on which the event distribution line is invoiced
DRAFT_INVOICE_ITEM_LINE_NUM	The draft invoice item line number on which the event distribution line is invoiced
BATCH_NAME	The reference to the GL je line in which the revenue was included when posted to GL. This value is a concatenation of the ccid, draft revenue gl date, and transfer request id separated by hyphens. Joins to GL_JE_LINES.REFERENCE_1
LINE_NUM_REVERSED	The distribution line number for the event that is reversed by this distribution line
REVERSED_FLAG	Flag that indicates if the distribution line is reversed by another distribution line
EVENT_NUM	The event number of the event that is revenue distributed by the distribution line
ORG_ID	Operating unit identifier for multi-organization installations
OUTPUT_VAT_TAX_ID	Identifier for default output tax code
OUTPUT_TAX_EXEMPT_FLAG	Standard, Exempt, or required Allows the user to use Standard Exemption rules, force an exemption or require tax to a normally exempt invoice This is defaulted based on user setup
OUTPUT_TAX_EXEMPT_REASON_CODE	Tax Exempt Reason for item lines that have tax_exempt_flag set to (E-exempt)
OUTPUT_TAX_EXEMPT_NUMBER	Exemption Certificate Number for item lines that have tax_exempt_flag set to (E-exempt)
PRC_GENERATED_FLAG	For future use
BILL_TRANS_CURRENCY_CODE	Bill transaction currency code for the expenditure item.
BILL_TRANS_AMOUNT	The billing amount of the item in the bill transaction currency.
REVPROC_CURRENCY_CODE	Base bill amount in the bill transaction currency.
REVPROC_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to revenue processing currency during revenue generation. Currently, the project functional currency is the revenue processing currency.
REVPROC_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to the revenue processing currency if Fixed Date rate date type is used during revenue generation. Currently, the project functional currency is the revenue processing
LINE_NUM	The sequential number that identifies the revenue distribution line for an event
REVPROC_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to revenue processing during revenue generation. Currently, the project functional currency is the revenue processing currency.
INVPROC_CURRENCY_CODE	Invoice processing currency.
INVPROC_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency during revenue generation
INVPROC_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during revenue generation
INVPROC_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functionalduring revenue generation.
PROJECT_CURRENCY_CODE	Project currency code.
PROJECT_REVENUE_AMOUNT	Revenue Amount in the project functional currency.
PROJECT_REV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency during revenue generation.
PROJECT_REV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used during revenue generation.
PROJECT_REV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency during revenue generation.
AMOUNT	The Revenue amount to be charged to the GL account for the event on a draft revenue in the revenue processing currency.
PROJECT_BILL_AMOUNT	Bill amount in the project currency. This is calculated by applying the conversion rules set up for project currency during invoice generation.
PROJECT_INV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency during invoice generation.
PROJECT_INV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used during invoice generation.
PROJECT_INV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency during invoice generation.
PROJFUNC_CURRENCY_CODE	Project functional currency code.
PROJFUNC_REVENUE_AMOUNT	Revenue amount in the project functional
PROJFUNC_REV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency during revenue generation.
PROJFUNC_REV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during revenue generation.
PROJFUNC_REV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functional currency during revenue
PROJFUNC_BILL_AMOUNT	Bill Amount in the project functional currency. This is calculated by applying the conversion rules set up for project functional currency during invoice generation.
CREATION_DATE	Standard Who Column
PROJFUNC_INV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency during invoice generation.
PROJFUNC_INV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used during invoice generation.
PROJFUNC_INV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functional currency during invoice generation.
FUNDING_CURRENCY_CODE	Funding currency code.
FUNDING_REVENUE_AMOUNT	Revenue amount in the funding currency.
FUNDING_REV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to funding currency during revenue generation.
FUNDING_REV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used during revenue generation.
FUNDING_REV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to funding currency during revenue generation.
FUNDING_BILL_AMOUNT	Bill amount in funding currency.
FUNDING_INV_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency during invoice generation.
CREATED_BY	Standard Who Column
FUNDING_INV_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project currency if Fixed Date rate date type is used during invoice generation.
FUNDING_INV_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency during invoice generation.
INV_GEN_REJECTION_CODE	Invoice generation rejection code.
RETN_DRAFT_INVOICE_NUM	Project invoice number. This will be used to drilldown the retention line from invoice review screen.
RETN_DRAFT_INVOICE_LINE_NUM	Project invoice retention line number. This will be used to drilldown the retention line from invoice review screen.
RETAINED_AMOUNT	Retained amount. This amount is in the invoice processing currency
RETENTION_RULE_ID	The identifier of the retention rule.
OUTPUT_TAX_CLASSIFICATION_CODE	eTax change
REVTRANS_AMOUNT	Transaction Amount in Revenue Currency
REVTRANS_CURRENCY_CODE	Revenue transaction currency code
REVPROC_REVTRANS_RATE_TYPE	Exchange rate type for conversion between revenue processing currency and revenue transaction currency
REVPROC_REVTRANS_RATE_DATE	Exchange rate date for conversion between revenue processing currency and revenue transaction currenc
REVPROC_REVTRANS_EX_RATE	Exchange rate for conversion between revenue processing currency and revenue transaction currenc
PROJECT_ID	The identifier of the project for which the revenue distribution line is generated. This project is the project for which the event is entered
DRAFT_REVENUE_NUM	The draft revenue number for which the revenue distribution line is generated
DRAFT_REVENUE_ITEM_LINE_NUM	The draft revenue item line number under which the revenue distribution line is generated

Projects - PA_CREDIT_RECEIVERS	Employees who receive credit for project revenue
Column Name	Descritpion
CREDIT_TYPE_CODE	The type of credit that the employee receives
PROJECT_ID	The identifier of the project for which the person receives credit
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
START_DATE_ACTIVE	First effective date of the credit receiver
CREDIT_PERCENTAGE	The percentage of credit for the credit type that the credit receiver earns
TASK_ID	The identifier of the task for which the employee receives credit. (No longer used. Only project level credit supported as of Version 3.1.)
PERSON_ID	The identifier of the employee who receives credit
END_DATE_ACTIVE	Last effective date of the credit receiver
TRANSFER_TO_AR_FLAG	Indicates whether to transfer the sales credit to Oracle Receivables when transferring an Oracle Receivables.
SALESREP_ID	Identifier of salesrep to which to transfer credit. Employee must be defined as salesrep in Oracle Receivables.
BUDGET_TYPE_CODE	obsolete column in 10.7
RECORD_VERSION_NUMBER	Record version number.
CREDIT_RECEIVER_ID	Uniqely identifies a credit receiver

Projects - PA_AGREEMENT_TYPES	Implementation-defined classifications of customer agreements
Column Name	Descritpion
AGREEMENT_TYPE	Implementation-defined name that uniquely identifies the agreement type
DESCRIPTION	Explanation of the agreement type
TERM_ID	The identifier of the payment term that defaults to agreements and specifies the schedule on which invoices funded by the agreement are to be paid
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment column.
ATTRIBUTE2	Descriptive flexfield segment column.
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE3	Descriptive flexfield segment column.
ATTRIBUTE4	Descriptive flexfield segment column.
ATTRIBUTE5	Descriptive flexfield segment column.
ATTRIBUTE6	Descriptive flexfield segment column.
ATTRIBUTE7	Descriptive flexfield segment column.
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE8	Descriptive flexfield segment column.
ATTRIBUTE9	Descriptive flexfield segment column.
ATTRIBUTE10	Descriptive flexfield segment column.
ATTRIBUTE11	Descriptive flexfield segment column.
ATTRIBUTE12	Descriptive flexfield segment column.
CREATION_DATE	Standard Who Column
ATTRIBUTE13	Descriptive flexfield segment column.
ATTRIBUTE14	Descriptive flexfield segment column.
ATTRIBUTE15	Descriptive flexfield segment column.
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REVENUE_LIMIT_FLAG	Default flag to agreements that indicates whether revenue and invoices for projects funded by the agreement can exceed the allocated funding amount
START_DATE_ACTIVE	First effective date of the agreement type
END_DATE_ACTIVE	Last effective date of the agreement type

Projects - PA_AGREEMENTS_ALL	Customer contracts that serve as the basis for work authorization
Column Name	Descritpion
AGREEMENT_ID	The system-generated number that uniquely identifies the agreement
LAST_UPDATE_DATE	Standard Who Column
INVOICE_LIMIT_FLAG	Flag indicating whether invoices for projects funded by this agreement can exceed the allocated funding amount
CUSTOMER_ORDER_NUMBER	The number used by the customer to track the Agreement.
LAST_UPDATED_BY	Standard Who Column
ADVANCE_REQUIRED	Flag indicating whether an advance payment is required before funding can be added
BILLING_SEQUENCE	The billing sequence number that indicates the order in which the agreement is to be billed
CREATION_DATE	Standard Who Column
START_DATE	The Start date of the agreement
LINE_OF_ACCOUNT	The accounting string that the customer is using to fund the agreement
CREATED_BY	Standard Who Column
PAYMENT_SET_ID	Indicates a unique reference for all the receipt from AR which are applied against the agreement.
ADVANCE_AMOUNT	Indicates total receipt amount applied against an agreement.
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
OWNED_BY_PERSON_ID	The identifier of the person that enters and owns the agreement
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield segment
ATTRIBUTE17	Descriptive flexfield segment
ATTRIBUTE18	Descriptive flexfield segment
ATTRIBUTE19	Descriptive flexfield segment
ATTRIBUTE20	Descriptive flexfield segment
ATTRIBUTE21	Descriptive flexfield segment
ATTRIBUTE22	Descriptive flexfield segment
CUSTOMER_ID	The identifier of the customer who is authorizing the agreement
TERM_ID	The identifier of the payment term which specifies the schedule on which the invoices funded by this agreement are to be paid
ATTRIBUTE23	Descriptive flexfield segment
ATTRIBUTE24	Descriptive flexfield segment
ATTRIBUTE25	Descriptive flexfield segment
REVENUE_LIMIT_FLAG	Flag indicating whether revenue for projects funded by this agreement can exceed the allocated funding amount
AGREEMENT_NUM	The user-entered number that identifies the agreement
AMOUNT	The amount of revenue authorized for the agreement
DESCRIPTION	The free text description to describe the agreement
AGREEMENT_TYPE	The agreement type that classifies the agreement
EXPIRATION_DATE	Date on which the agreement expires
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
TEMPLATE_FLAG	Indicates if agreement template is used in Quick Agreement functionality of project templates
ORG_ID	Operating unit identifier for multi-organization installations
PM_AGREEMENT_REFERENCE	The identifier of the agreement in the external system from which the agreement was imported.
PM_PRODUCT_CODE	The identifier of the external system from which the agreement was imported.
OWNING_ORGANIZATION_ID	Agreement owning operating unit
AGREEMENT_CURRENCY_CODE	Agreement currency code of the agreement

Projects - PA_BATCH_SOURCES	System-defined sources of expense report expenditure batches
Column Name	Descritpion
BATCH_SOURCE	Name of the batch source
MEANING	Short, user-friendly name that describes the batch source
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DESCRIPTION	Explanation of the batch source

Projects - PA_COST_BASE_EXP_TYPES	Expenditure types associated with cost bases
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COST_PLUS_STRUCTURE	The name of the burden structure
COST_BASE	The name of the cost base
COST_BASE_TYPE	The type of the cost base
EXPENDITURE_TYPE	The name of the expenditure type that is based on the cost base

Projects - PA_COST_PLUS_STRUCTURES	Structures used for burdening
Column Name	Descritpion
END_DATE_ACTIVE	Last effective date of the burden structure
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
COST_PLUS_STRUCTURE	The implementation-defined name that uniquely identifies the burden structure
LAST_UPDATE_LOGIN	Standard Who Column
ALLOWED_FOR_OVERRIDE_SCH_FLAG	Flags that indicates if the burden structure can be used for schedule overrides
DEFAULT_FOR_OVERRIDE_SCH_FLAG	Flag that indicates if the burden structure is the default structure used for schedule overrides
DESCRIPTION	The description of the burden structure
COST_PLUS_STRUCTURE_TYPE	The type of the burden structure
START_DATE_ACTIVE	First effective date of the burden structure

Projects - PA_COST_BASE_COST_CODES	Burden cost codes associated with cost bases
Column Name	Descritpion
IND_COST_CODE	The name of the burden cost code which is based on the cost base
PRECEDENCE	The build-up precedence of the burden cost code within the cost base
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
COST_BASE_COST_CODE_ID	The system-generated number that uniquely identifies the cost base and burden cost code
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COST_PLUS_STRUCTURE	The name of the burden structure
COST_BASE	The name of the cost base
COST_BASE_TYPE	The type of the cost base

Projects - PA_COST_BASES	Implementation-defined groupings of expenditure types used for burdening
Column Name	Descritpion
REPORT_SORT_ORDER	The cost base display sequence on the report
DESCRIPTION	The description of the cost base
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
COST_BASE	The implementation-defined name that groups expenditure types and burden cost codes
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COST_BASE_TYPE	The type of the cost base
START_DATE_ACTIVE	First effective date of the cost base
END_DATE_ACTIVE	Last effective date of the cost base

Projects - PA_COMPILED_MULTIPLIERS	Buildup multipliers used for burdening
Column Name	Descritpion
PRECEDENCE	The precedence of burden cost code within the cost base
COMPILED_MULTIPLIER	The build-up multiplier for the cost base, burden cost code, and compiled set according to the precedence
MULTIPLIER	The original multiplier defined in the burden schedule revision
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
IND_COMPILED_SET_ID	The identifier of the compiled set
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
COST_BASE_COST_CODE_ID	The identifier of cost code used in the cost base
COST_BASE	The name of the cost base, denormalized from PA_COST_BASE_COST_CODES.
IND_COST_CODE	The name of the burden cost code, denormalized from PA_COST_BASE_COST_CODES

Projects - PA_BILLING_EXTENSIONS	Implementation-defined billing extension definitions
Column Name	Descritpion
PERCENTAGE_REQD_FLAG	When set to 'Yes' users would be forced to enter a percentage when assigning a Billing Extension
DEFAULT_COST_PLAN_TYPE_ID	If no Revenue Fin plan Type id is passed to the predefined procedure that determines the Fin plan budget amount (Supplied by Projects), this default revenue fin plan type id to be used when determining revenue fin plan amounts
CALL_AFTER_CONCESSION_INV_FLAG	Flag that specifies if the billing extension is to be called during concession invoice processing
CALLING_PROCESS	This can have the values 'Revenue', 'Invoice' or 'Both'. This field will determine which program will execute the billing extension
PRE_PROCESSING_FLAG	When this flag is set the Billing Extension will be called before any processing (Revenue accrual or Invoicing) has occurred
POST_PROCESSING_FLAG	When this flag is set the Billing Extension will be called after all processing (Revenue accrual or Invoicing) has taken place
CALL_AFTER_REG_FLAG	When this flag is set the Billing Extension will be called after all regular transactions have been processed. Events created in this section will be attached to the regular draft revenue/invoice
BILLING_EXTENSION_ID	Primary key for the table
CALL_AFTER_ADJ_FLAG	When this flag is set the Billing Extension will be called after all crediting transactions are processed. The event created in this section will be attached to the crediting draft invoice/revenue
PROJECT_SPECIFIC_FLAG	When this flag is set the Billing Extension can only be assigned at the Project/Task level and not at the Project Type level
MARK_EXP_ITEMS_FLAG	This column is there for future use. It will be used to indicate whether events created by this Billing Extension should FIFO mark expenditure items
DESCRIPTION	Description of the Billing Extension
DEFAULT_EVENT_DESCRIPTION	If no description is passed to the pre-defined procedure that inserts the events (supplied by PA), this default event description will be used as the event description
PROCESSING_ORDER	Billing Extensions will be executed in the order specified here. A Billing Extension with a processing_order of 10 will execute before a Billing Extension with a processing_order of 20
START_DATE_ACTIVE	When assigning Billing Extensions only Billing Extensions with a start date before sysdate will show up in the quickpick
END_DATE_ACTIVE	When assigning Billing Extensions only Billing Extensions with an end date after sysdate will show up in the quickpick
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
NAME	This is the name of the Billing Extension which will show up in quickpicks when the Billing Extension has to be assigned
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
PROCEDURE_NAME	This is the exact package.procedure name that the appropriate program will execute from within the database when the Billing Extension is called
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
TRX_INDEPENDENT_FLAG	When this flag is set the Billing Extension will be called even if there are no transactions being processed
AMOUNT_REQD_FLAG	When set to 'Yes' users will be forced to enter an amount when assigning the Billing Extension
DEFAULT_EVENT_TYPE	If no description is passed to the pre-defined procedure that inserts the events (supplied by PA), this default event type be used when inserting the event
CALL_BEFORE_DEL_FLAG	When this flag is set the billing extension will be called before revenue or invoice transactions are deleted
DEFAULT_COST_BUDGET_TYPE_CODE	If no Cost Budget Type Code is passed to the pre-defined procedure that determines the cost budget amount (Supplied by Projects),this default cost budget type code will be used when determining cost budget amounts
DEFAULT_REV_BUDGET_TYPE_CODE	If no Revenue Budget Type Code is passed to the pre-defined procedure that determines the cost budget amount (Supplied by Projects), this default revenue budget type code to be used when determining revenue budget amounts
CALL_AFTER_CANCEL_INV_FLAG	When this flag is set the billing extension will be called after cancellation invoice processing
CALL_AFTER_WOFF_INV_FLAG	When this flag is set the billing extension will be called after write-off invoice processing
CALL_POST_REG_FLAG	When this flag is set the billing extension will be called after regular automatic event processing.
PREDEFINED_FLAG	When this flag is set it indicates that the billing extension is predefined
DEFAULT_REV_PLAN_TYPE_ID	If no Revenue Fin plan Type id is passed to the predefined procedure that determines the Fin plan budget amount (Supplied by Projects), this default revenue fin plan type id to be used when determining revenue fin plan amounts

Projects - PA_BILLING_ASSIGNMENTS_ALL	Assignments of billing extensions to a project type, project, or task
Column Name	Descritpion
TOP_TASK_ID	If this field is populated the Billing Extension specified by this row will be called for this top task
PROJECT_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project currency for customer billing
PROJECT_RATE_DATE	Exchange rate date to use for conversion between from bill transaction currency to project currency if Fixed Date Fixed Date rate date type usedrate date type is used for customer billing.
PROJECT_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project currency if User exchange rate type is used
PROJFUNC_CURRENCY_CODE	Project functional currency
AMOUNT	When assigning a Billing Extension a value may be entered here which can then be referenced by the Billing Extension when it is being executed.
PROJFUNC_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to project functional currency for customer billing
PROJFUNC_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to project functional currency if Fixed Date rate date type is used for customer billing
PERCENTAGE	Similar to amount, a value may be entered here when assigning the Billing Extension.
PROJFUNC_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project functional if User exchange rate type is used
FUNDING_RATE_TYPE	Exchange rate type to use for conversion from bill transaction currency to funding currency for customer billing
ACTIVE_FLAG	When this value is set the Billing Extension will be called (all other criteria being met). If it is not set the Billing Extension will not be called.
FUNDING_RATE_DATE	Exchange rate date to use for conversion from bill transaction currency to funding currency if Fixed Date rate date type is used
FUNDING_EXCHANGE_RATE	Exchange rate to use for conversion from bill transaction currency to project or functional currency if User exchange rate type is used
BILLING_ASSIGNMENT_ID	Primary key
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
BILLING_EXTENSION_ID	Foreign key to PA_BILLING_EXTENSIONS
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
PROJECT_TYPE	If this field is populated the Billing Extension specified by this row will be called for any project of this project type.
DISTRIBUTION_RULE	Used for internal processing
ORG_ID	Operating unit identifier for multi-organization installations
RECORD_VERSION_NUMBER	Stores record number for locking purposes.
PROJECT_ID	If this field is populated the Billing Extension specified by this row will be called for this project
RATE_OVERRIDE_CURRENCY_CODE	Bill rate override currency code
PROJECT_CURRENCY_CODE	Project Currency

Projects - PA_BILLING_MESSAGES	Messages issued by billing extensions to assist in debugging
Column Name	Descritpion
CALLING_PROCESS	The process (Revenue/Invoice) that is executing when the Billing Extension inserts the message.
CALLING_PLACE	The place in the program that the Billing Extension is called from when the message is inserted
REQUEST_ID	Standard Who Column
MESSAGE	The message specified by the Clients Billing Extension when calling pb_public.insert_message
LAST_UPDATE_DATE	Standard Who Column
INSERTING_PROCEDURE_NAME	This field contains the name of the procedure that a Client Billing Extension specifies when inserting a message using pb_public.insert_message.
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
BILLING_ASSIGNMENT_ID	The Billing assignment id of the Billing Extension that inserts the message. The procedure PA supplies populates this value automatically.
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LINE_NUM	If the same Billing Extension inserts several messages in the same call, the line num will be incremented for each message
PROJECT_ID	The project_id of the project being processed when the Billing Extension inserts the message. This is automatically inserted by the PA procedure.
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
TASK_ID	The task_id of the project being processed when the Billing Extension inserts the message. This is automatically inserted by the PA procedure.

Projects - PA_ACCUM_COLUMNS	System-defined configurable columns used in project summarization
Column Name	Descritpion
PROJECT_TYPE_CLASS_CODE	Type of the project for which the column values apply
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
COLUMN_ID	Sequence generated id for the Accumulation Column
ACCUM_CATEGORY_CODE	Indicates the accumulation category to which this column belongs. For example, 'BUDGETS', 'ACTUALS', or 'COMMITMENTS'.
ACCUM_COLUMN_CODE	Column to be summarized
DESCRIPTION	The column description
ACCUM_FLAG	Indicates whether the column is to be included when summarizing Actuals,Budgets etc.
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
CREATION_DATE	Standard Who Column

Projects - PA_ACCUM_COLUMN_VALUES	10SC Only
Column Name	Descritpion
COLUMN_ID	Sequence generated id for the Accumulation Column
COLUMN_VALUE	This columns holds the accumulated amount.
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_BUDGET_ENTRY_METHODS	Implementation-defined methods for entering budgets
Column Name	Descritpion
BUDGET_ENTRY_METHOD_CODE	The unique identifier of the budget entry method
CATEGORIZATION_CODE	The resource categorization that is used for budget entry
COST_QUANTITY_FLAG	Flag that indicates whether cost quantity is enterable
RAW_COST_FLAG	Flag that indicates whether raw cost is enterable
BURDENED_COST_FLAG	Flag that indicates whether burdened cost is enterable
REV_QUANTITY_FLAG	Flag that indicates whether revenue quantity is enterable
REVENUE_FLAG	Flag that indicates whether revenue is enterable
TIME_PHASED_TYPE_CODE	The indicator of what time periods, if any, to use for budget entry
END_DATE_ACTIVE	Last effective date of the budget entry method
LAST_UPDATE_DATE	Standard Who Column
DESCRIPTION	The description of the budget entry method
PREDEFINED_FLAG	Indicates that the entry method has been pre-defined by Oracle Projects
ATTRIBUTE_CATEGORY	Descriptive Flexfield context
ATTRIBUTE1	Descriptive flexfield segment column.
ATTRIBUTE2	Descriptive flexfield segment column.
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE3	Descriptive flexfield segment column.
ATTRIBUTE4	Descriptive flexfield segment column.
ATTRIBUTE5	Descriptive flexfield segment column.
ATTRIBUTE6	Descriptive flexfield segment column.
ATTRIBUTE7	Descriptive flexfield segment column.
CREATION_DATE	Standard Who Column
ATTRIBUTE8	Descriptive flexfield segment column.
ATTRIBUTE9	Descriptive flexfield segment column.
ATTRIBUTE10	Descriptive flexfield segment column.
ATTRIBUTE11	Descriptive flexfield segment column.
ATTRIBUTE12	Descriptive flexfield segment column.
CREATED_BY	Standard Who Column
ATTRIBUTE13	Descriptive flexfield segment column.
ATTRIBUTE14	Descriptive flexfield segment column.
ATTRIBUTE15	Descriptive flexfield segment column.
LAST_UPDATE_LOGIN	Standard Who Column
BUDGET_ENTRY_METHOD	The short, user-friendly name of the budget entry method
START_DATE_ACTIVE	First effective date of the budget entry method
ENTRY_LEVEL_CODE	The level that is used for budget entry

Projects - PA_BUDGET_LINES	Detail lines of project and task budgets
Column Name	Descritpion
RESOURCE_ASSIGNMENT_ID	The identifier of the resource assignment of the budget line
QUANTITY	The quantity of the budget line
REVENUE_ADJ	The revenue adjustment of budget line
LENT_RESOURCE_COST	The lent resource cost of budget line
RAW_COST	The raw cost of the budget line
TP_COST_IN	The transfer-price cost in of budget line
TP_COST_OUT	The transfer-price cost out of budget line
BURDENED_COST	The burdened cost of the budget line
COST_ADJ	The cost adjustment of budget line
UNASSIGNED_TIME_COST	The unassigned time cost of budget line
REVENUE	The revenue of the budget line
UTILIZATION_PERCENT	The utilization percent of budget line
UTILIZATION_HOURS	The utilization hours of budget line
CHANGE_REASON_CODE	The reason to create the budget line
UTILIZATION_ADJ	The utilization percent adjustment of budget line
CAPACITY	The capacity of budget line
DESCRIPTION	The description of the budget line
HEAD_COUNT	The head count of budget line
HEAD_COUNT_ADJ	The head count adjustment of budget line
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
PROJFUNC_CURRENCY_CODE	The project functional currency code
PROJFUNC_COST_RATE_TYPE	The project functional cost rate type
ATTRIBUTE1	Descriptive flexfield segment
PROJFUNC_COST_EXCHANGE_RATE	The project functional cost exchange rate
PROJFUNC_COST_RATE_DATE_TYPE	The project functional cost rate date type
ATTRIBUTE2	Descriptive flexfield segment
PROJFUNC_COST_RATE_DATE	The cost rate date for project functional currency
PROJFUNC_REV_RATE_TYPE	The project functional revenue rate type
ATTRIBUTE3	Descriptive flexfield segment
PROJFUNC_REV_EXCHANGE_RATE	The project functional revenue exchange rate
PROJFUNC_REV_RATE_DATE_TYPE	The project functional revenue rate date type
START_DATE	The start date of the budget line
ATTRIBUTE4	Descriptive flexfield segment
PROJFUNC_REV_RATE_DATE	The revenue rate date for project functional currency
PROJECT_CURRENCY_CODE	The project currency code
ATTRIBUTE5	Descriptive flexfield segment
PROJECT_COST_RATE_TYPE	The project cost rate type
PROJECT_COST_EXCHANGE_RATE	The project cost exchange rate
ATTRIBUTE6	Descriptive flexfield segment
PROJECT_COST_RATE_DATE_TYPE	The project cost rate date type
PROJECT_COST_RATE_DATE	The cost rate date for project currency
ATTRIBUTE7	Descriptive flexfield segment
PROJECT_RAW_COST	The project raw cost
PROJECT_BURDENED_COST	The project burdened cost
ATTRIBUTE8	Descriptive flexfield segment
PROJECT_REV_RATE_TYPE	The project revenue rate type
PROJECT_REV_EXCHANGE_RATE	The project revenue exchange rate
ATTRIBUTE9	Descriptive flexfield segment
PROJECT_REV_RATE_DATE_TYPE	The project revenue rate date type
PROJECT_REV_RATE_DATE	The revenue rate date for project currency
ATTRIBUTE10	Descriptive flexfield segment
PROJECT_REVENUE	The project revenue
TXN_CURRENCY_CODE	The transaction currency code of the amount
ATTRIBUTE11	Descriptive flexfield segment
TXN_RAW_COST	The raw cost in transaction currency
TXN_BURDENED_COST	The burdened cost in transaction currency
ATTRIBUTE12	Descriptive flexfield segment
TXN_REVENUE	The revenue in transaction currency
BUCKETING_PERIOD_CODE	Determines whether bucket is for preceding or succeeding periods
ATTRIBUTE13	Descriptive flexfield segment
BUDGET_LINE_ID	Unique identifier of budget line
BUDGET_VERSION_ID	Unique identifier of budget version
LAST_UPDATE_DATE	Standard who column
ATTRIBUTE14	Descriptive flexfield segment
TXN_STANDARD_COST_RATE	It stores the standard cost rate
ATTRIBUTE15	Descriptive flexfield segment
TXN_COST_RATE_OVERRIDE	It stores the overriding cost rate of the assignment.
COST_IND_COMPILED_SET_ID	The identifier of the compiled set that is used to calculate the cost amount of the expenditure item
TXN_BURDEN_MULTIPLIER	It stores the burden multiplier
RAW_COST_SOURCE	Currently not used
TXN_BURDEN_MULTIPLIER_OVERRIDE	The override burden multiplier
TXN_STANDARD_BILL_RATE	The standard bill rate
BURDENED_COST_SOURCE	Currently not used
TXN_BILL_RATE_OVERRIDE	The override bill rate
TXN_MARKUP_PERCENT	The markup percent.
QUANTITY_SOURCE	Currently not used
TXN_MARKUP_PERCENT_OVERRIDE	The override markup percent
TXN_DISCOUNT_PERCENTAGE	The discount percentage
REVENUE_SOURCE	Currently not used
LAST_UPDATED_BY	Standard who column
PM_PRODUCT_CODE	The identifier of the external project management system from which the budget was imported.
TRANSFER_PRICE_RATE	It stores the transfer price rate
INIT_QUANTITY	It stores the initial quantity
PM_BUDGET_LINE_REFERENCE	The identifier of the budget in the external project management system from which the budget was imported
INIT_QUANTITY_SOURCE	It stores the initial quantity source
INIT_RAW_COST	It stores the initial raw cost in project functional currency
INIT_BURDENED_COST	It stores the initial burdened cost in project functional currency
INIT_REVENUE	It stores the initial revenue in project functional currency
INIT_RAW_COST_SOURCE	It stores the initial raw cost source
COST_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of cost amounts.
INIT_BURDENED_COST_SOURCE	It stores the initial burdened cost source
INIT_REVENUE_SOURCE	It stores the initial revenue source
CREATION_DATE	Standard who column
PROJFUNC_INIT_COST_RATE_TYPE	The initial cost rate type for project functional currency
PROJFUNC_INIT_COST_EXCH_RATE	The initial cost exchange rate for project functional currency
PROJFUNC_INT_COST_RATE_DT_TYPE	The initial cost rate date type for project functional currency
REVENUE_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of revenue amounts.
PROJFUNC_INIT_COST_RATE_DATE	The initial cost rate date for project functional currency
PROJFUNC_INIT_REV_RATE_TYPE	The initial revenue rate type for project functional currency
PROJFUNC_INIT_REV_EXCH_RATE	The initial revenue exchange rate for project functional currency
PROJFUNC_INIT_REV_RATE_DT_TYPE	The initial revenue rate date type for project functional currency
PROJFUNC_INIT_REV_RATE_DATE	The initial revenue rate date for project functional currency
BURDEN_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of burdened cost amounts.
PROJECT_INIT_COST_RATE_TYPE	The initial cost rate type for project currency
PROJECT_INIT_COST_EXCH_RATE	The initial cost exchange rate for project currency
CREATED_BY	Standard who column
PROJECT_INIT_COST_RATE_DT_TYPE	The initial cost rate date type for project currency
PROJECT_INIT_COST_RATE_DATE	The initial cost rate date for project currency
PROJECT_INIT_RAW_COST	The initial raw cost in project currency
OTHER_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an unexpected error is encountered.
PROJECT_INIT_BURDENED_COST	The initial burdened cost in project currency
PROJECT_INIT_REV_RATE_TYPE	The initial revenue rate type for project currency
PROJECT_INIT_REV_EXCH_RATE	The initial revenue exchange rate for project currency
PROJECT_INIT_REV_RATE_DT_TYPE	The initial revenue rate date type for project currency
PROJECT_INIT_REV_RATE_DATE	The initial revenue rate date for project currency
CODE_COMBINATION_ID	Accounting code identifier for the budget line
PROJECT_INIT_REVENUE	The initial revenue in project currency
TXN_INIT_RAW_COST	The initial raw cost in transaction currency
LAST_UPDATE_LOGIN	Standard who column
TXN_INIT_BURDENED_COST	The initial burdened cost in transaction currency
TXN_INIT_REVENUE	The initial revenue in transaction currency
BURDEN_COST_RATE	The burden cost rate in transaction currency
BURDEN_COST_RATE_OVERRIDE	The burden cost rate override in transaction currency
CCID_GEN_STATUS_CODE	This indicates the following for accounting code generation : (P) Pending, (G) Generated, (E) Error in Generating Account.
PC_CUR_CONV_REJECTION_CODE	Indicates the rejection code while trying to convert the transaction currency into project currency.
PFC_CUR_CONV_REJECTION_CODE	Indicates the rejection code while trying to convert the transaction currency into project functional currency.
SYSTEM_REFERENCE_NUM1	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_NUM2	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_NUM3	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_VAR1	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_VAR2	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_VAR3	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_DAT1	Budget line reference column used for internal purpose
SYSTEM_REFERENCE_DAT2	Budget line reference column used for internal purpose
CCID_GEN_REJ_MESSAGE	Message for account generation failure reason.
SYSTEM_REFERENCE_DAT3	Budget line reference column used for internal purpose
BC_EVENT_ID	Budgetary control event identifier
BC_REV_EVENT_ID	Budgetary control reversal event identifier
PBE_ID
DISPLAY_QUANTITY	"Used to display quantity for rate based planning resource"
END_DATE	The end date of the budget line
REQUEST_ID	The concurrent request id of the budget line being processed
BORROWED_REVENUE	The borrowed revenue of budget line
PERIOD_NAME	The period of the budget line
TP_REVENUE_IN	The transfer-price revenue in of budget line
TP_REVENUE_OUT	The transfer-price revenue out of budget line

Projects - PA_BUDGET_TYPES	Implementation-defined classifications of types of budgets used for different business purposes
Column Name	Descritpion
BUDGET_TYPE_CODE	The unique identifier of budget type
PREDEFINED_FLAG	Flag that indicates if the budget type is predefined.
ACCUMULATION_FLAG	Flag that indicates if the budget type is to be summarized for project summary amount. Currently it is not used. All budget types are summarized.
END_DATE_ACTIVE	Last effective date of the budget type
DESCRIPTION	The description of the budget type
ENABLE_WF_FLAG	This column indicates if a budget approval workflow can be enabled for this budget type.
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who Column
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
CREATION_DATE	Standard Who Column
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ADW_NOTIFY_FLAG	The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
CREATED_BY	Standard Who Column
PLAN_TYPE	Stores the type of plan.
UPGRADE_BUDGET_TYPE_FLAG	Indicates that the budget type is eligible for upgrade
LAST_UPDATE_LOGIN	Standard Who Column
BUDGET_TYPE	The short, user-friendly name of the budget type
START_DATE_ACTIVE	First effective date of the budget type
BUDGET_AMOUNT_CODE	Indicator if budget type is used for cost or revenue budget

Projects - PA_BUDGET_VERSIONS	Versions of project budgets
Column Name	Descritpion
BUDGET_VERSION_ID	The system-generated number that uniquely identifies the budget version
LAST_UPDATE_LOGIN	Standard Who Column
TOTAL_TP_REVENUE_IN	The total transfer-price revenue in of financial plan.
TOTAL_TP_REVENUE_OUT	The total transfer-price revenue out of financial plan.
CURRENT_FLAG	Flag that indicates whether the budget version is the current baselined budget
TOTAL_REVENUE_ADJ	The total revenue adjustment of financial plan.
TOTAL_LENT_RESOURCE_COST	The total lent resource cost of financial plan.
ORIGINAL_FLAG	Flag that indicates whether the budget version was an original budget at any time
TOTAL_TP_COST_IN	The total transfer-price cost in of financial plan
TOTAL_TP_COST_OUT	The total transfer-price cost out of financial plan.
CURRENT_ORIGINAL_FLAG	Flag that indicates whether the budget version is the current original budget
TOTAL_COST_ADJ	The total cost adjustment of financial plan
TOTAL_UNASSIGNED_TIME_COST	The total unassigned time cost of financial plan
RESOURCE_ACCUMULATED_FLAG	Flag that indicates whether the budget version is summarized by resource accumulation in the project summary amount
TOTAL_UTILIZATION_PERCENT	The total utilization percent of financial plan
TOTAL_UTILIZATION_HOURS	The total utilization hours of financial plan.
RESOURCE_LIST_ID	The identifier of the resource list used by the budget version
TOTAL_UTILIZATION_ADJ	The Total utilization percent adjustment of financial plan.
TOTAL_CAPACITY	The total capacity of financial plan.
VERSION_NAME	The name of the budget version
TOTAL_HEAD_COUNT	The total head count of financial plan.
TOTAL_HEAD_COUNT_ADJ	The total head count adjustment of financial plan
BUDGET_ENTRY_METHOD_CODE	The method used to enter the budget version
CURRENT_WORKING_FLAG	Indicates that this is the current working version of the financial plan
VERSION_TYPE	The planning type of the financial plan. Valid values are COST, REVENUE, ALL and ORG_FORECAST
BASELINED_BY_PERSON_ID	The identifier of the person who baselined the budget
REQUEST_ID	The concurrent request id of the budget version being processed
TOTAL_PROJECT_RAW_COST	The raw cost in project currency
BASELINED_DATE	The baselined date of the budget version
TOTAL_PROJECT_BURDENED_COST	The burdened cost in project currency
TOTAL_PROJECT_REVENUE	The revenue in project currency
PROJECT_ID	The identifier of the project for which the budget is entered
CHANGE_REASON_CODE	The reason to create this budget version
LOCKED_BY_PERSON_ID	Identifier of the person who has locked the plan version
APPROVED_COST_PLAN_TYPE_FLAG	Indicates whether the plan version is an Approved Cost version
LABOR_QUANTITY	The number of labor hours budgeted for the project. This is a denormalized column which sums the quantities for all labor resources budgeted.
APPROVED_REV_PLAN_TYPE_FLAG	Indicates whether the plan version is an Approved Revenue version
EST_PROJECT_RAW_COST	Stores the estimated raw cost in project currency. Applicable only if the version is in the context of a change document.
LABOR_UNIT_OF_MEASURE	The unit of measure of labor hours for the project. This is always set to Hours.
EST_PROJECT_BURDENED_COST	Stores the estimated burdened cost in project currency. Applicable only if the version is in the context of a change document.
EST_PROJECT_REVENUE	Stores the estimated revenue in project currency. Applicable only if the version is in the context of a change document
RAW_COST	The raw cost budget of the project. This is a denormalized column
EST_QUANTITY	Stores the quantity of people resources. Applicable only if the version is in the context of a change document
EST_PROJFUNC_RAW_COST	Stores the estimated raw cost in project functional currency. Applicable only if the version is in the context of a change document
BURDENED_COST	The burdened cost budget of the project. It is a denormalized column
EST_PROJFUNC_BURDENED_COST	Stores the estimated burdened cost in project functional currency. Applicable only if the version is in the context of a change document.
EST_PROJFUNC_REVENUE	Stores the estimated revenue in project functional currency. Applicable only if the version is in the context of a change document
REVENUE	The revenue budget of the project. This is a denormalized column
CI_ID	Unique Identifier of the Control Item to which the plan version pertains to
AGREEMENT_ID	Unique Identifier of the agreement that is impacted by the Control Item
DESCRIPTION	The description of the budget version
PROCESS_UPDATE_WBS_FLAG	This column indicates whether the budget version requires a planning elements refresh
OBJECT_TYPE_CODE	The source object for the budget. Or forecast (Intended for future use)
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
OBJECT_ID	Indicates the source (Intended for future use)
PRIMARY_COST_FORECAST_FLAG	Indicates if the plan type is a primary cost forecast
ATTRIBUTE1	Descriptive flexfield segment
PRIMARY_REV_FORECAST_FLAG	Indicates if the plan type is a primary revenue forecast
REV_PARTIALLY_IMPL_FLAG	Indicates if change order impact has been partially implemented. This column is maintained for the change order version.
ATTRIBUTE2	Descriptive flexfield segment
RBS_STRUCT_VERSION_ID	The resource breakdown structure used for the plan version
EQUIPMENT_QUANTITY	The number of equipment hours budgeted for the project. This is a denormalized column which sums the quantities for all equipment resources budgeted.
BUDGET_TYPE_CODE	The type of budget
ATTRIBUTE3	Descriptive flexfield segment
PJI_SUMMARIZED_FLAG	Indicates whether the budget version has been extracted for reporting summary.
WP_VERSION_FLAG	Indicates whether the budget version is used for work plan.
ATTRIBUTE4	Descriptive flexfield segment
CURRENT_PLANNING_PERIOD	Indicates anchoring period for a budget versions.
PERIOD_MASK_ID	The identifier of the period mask that is used for the plan version
ATTRIBUTE5	Descriptive flexfield segment
LAST_AMT_GEN_DATE	This column stores the amount generated date for the plan version.
ACTUAL_AMTS_THRU_PERIOD	This column stores the PA/GL period to which the actual amounts have been copied to the plan version by the amount generation process.
ATTRIBUTE6	Descriptive flexfield segment
EST_EQUIPMENT_QUANTITY	Stores the estimated quantity of equipment resources. Applicable only if the version is in the context of a change document
ETC_START_DATE	This column stores the Estimate To Complete start date.
ATTRIBUTE7	Descriptive flexfield segment
PURGED_FLAG	Purged version flag
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
VERSION_NUMBER	The version number of the budget. For draft budget, the version number is always 1, for baselined budget this number is increased sequentially
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
FIRST_BUDGET_PERIOD	First period for which to display amounts in budget matrix window
PM_PRODUCT_CODE	The identifier of the external project management system from which the budget was imported.
PM_BUDGET_REFERENCE	The identifier of the budget in the external project management system from which the budget was imported
BUDGET_STATUS_CODE	The status of a budget.
WF_STATUS_CODE	This column stores the workflow status code for Budget Approval workflows
ADW_NOTIFY_FLAG	The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
PRC_GENERATED_FLAG	For Future Use
LAST_UPDATE_DATE	Standard Who Column
PLAN_RUN_DATE	This column applies to Project Forecasting. Indicates the date on which a forecast plan was generated.
PLAN_PROCESSING_CODE	This column applies to Project Forecasting. Indicates the process status of forecast generation.
LAST_UPDATED_BY	Standard Who Column
RECORD_VERSION_NUMBER	Internally generated number used for record locking
PERIOD_PROFILE_ID	The identifier of the period profile that is used for the plan version
CREATION_DATE	Standard Who Column
FIN_PLAN_TYPE_ID	The identifier of financial plan type
PARENT_PLAN_VERSION_ID	The identifier of the parent plan version. Applicable only for Organization forecast versions belonging to Sub-organizations.
CREATED_BY	Standard Who Column
PROJECT_STRUCTURE_VERSION_ID	The identifier of the project structure version. Applicable only if the version is in the context of an organization project or workplan version.
TOTAL_BORROWED_REVENUE	The total borrowed revenue of the financial plan

Projects - PA_COMMITMENT_TXNS	Commitment transactions for summarized project summary commitment amounts
Column Name	Descritpion
CMT_LINE_ID	Identifier of the commitment.
PA_PERIOD	PA period corresponding to the commitment.
GL_PERIOD	GL period corresponding to the commitment.
CMT_LINE_NUMBER	The requisition, purchase order or invoice line number in which the distribution is included.
CMT_CREATION_DATE	Date on which the requisition or purchase order was created or the invoice was incurred.
CMT_APPROVED_DATE	Date on which the requisition, purchase order or invoice was approved
CMT_REQUESTOR_NAME	The full name of requestor.
CMT_BUYER_NAME	The full name of buyer.
CMT_APPROVED_FLAG	Indicator if the commitment is approved: 'Y' for approved, 'N' for not approved.
CMT_PROMISED_DATE	Promised delivery date for commitment.
CMT_NEED_BY_DATE	Date that commitment is needed by.
PROJECT_ID	Identifier of the project.
CMT_HEADER_ID	Identifier for the Supplier on a commitment document.
ORGANIZATION_ID	Identifier of the expenditure organization incurring the commitment.
VENDOR_ID	Identifier of the Supplier.
VENDOR_NAME	Supplier Name.
EXPENDITURE_TYPE	Commitment expenditure type.
EXPENDITURE_CATEGORY	The expenditure category of the commitment expenditure type.
REVENUE_CATEGORY	The revenue category of the commitment expenditure type.
SYSTEM_LINKAGE_FUNCTION	Commitment system linkage function: VENDOR_INVOICES.
UNIT_OF_MEASURE	Not currently used in Oracle Projects, Version 4.0.
UNIT_PRICE	Cost per unit of the project-related commitment distribution.
TASK_ID	Identifier of the lowest level task.
CMT_IND_COMPILED_SET_ID	Identifier for the commitment's burden compiled set.
TOT_CMT_RAW_COST	The project currency raw cost amount of the project-related commitment distribution. This amount is derived by the commitment summarization process.
TOT_CMT_BURDENED_COST	The project currency burdened cost amount of the project-related commitment distribution. This amount is derived by the commitment summarization process.
TOT_CMT_QUANTITY	Outstanding quantity of the project-related commitment distribution.
QUANTITY_ORDERED	Distribution quantity ordered.
AMOUNT_ORDERED	Distribution amount ordered.
ORIGINAL_QUANTITY_ORDERED	Distribution original quantity ordered.
ORIGINAL_AMOUNT_ORDERED	Distribution original amount ordered.
QUANTITY_CANCELLED	Distribution quantity cancelled.
AMOUNT_CANCELLED	Distribution amount cancelled.
TRANSACTION_SOURCE	Source of commitment, i.e., ORACLE_PURCHASING, ORACLE_PAYABLES, OUTSIDE_SYSTEM.
QUANTITY_DELIVERED	Distribution quantity delivered.
AMOUNT_DELIVERED	Distribution amount delivered.
QUANTITY_INVOICED	Distribution quantity invoiced.
AMOUNT_INVOICED	Distribution amount invoiced.
QUANTITY_OUTSTANDING_DELIVERY	Distribution quantity outstanding delivery.
AMOUNT_OUTSTANDING_DELIVERY	Distribution amount outstanding delivery.
QUANTITY_OUTSTANDING_INVOICE	Distribution quantity outstanding invoice.
AMOUNT_OUTSTANDING_INVOICE	Distribution amount outstanding invoice.
QUANTITY_OVERBILLED	Distribution quantity overbilled.
AMOUNT_OVERBILLED	Distribution amount overbilled.
LINE_TYPE	Commitment line type is part of QuickCode.
ORIGINAL_TXN_REFERENCE1	Used to store original transaction reference for commitments from external systems.
ORIGINAL_TXN_REFERENCE2	Used to store original transaction reference for commitments from external systems.
ORIGINAL_TXN_REFERENCE3	Used to store original transaction reference for commitments from external systems.
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
CMT_NUMBER	The number of the commitment document.
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
BURDEN_SUM_SOURCE_RUN_ID	Burden summarization source run id. Id will identify all the commitment items summarized in the run to create summarized commitment items
BURDEN_SUM_DEST_RUN_ID	Burden summarization Destination run id. Id will identify commitment items created by burden component summarization process
BURDEN_SUM_REJECTION_CODE	Burden component summarization rejection code
RECEIPT_CURRENCY_CODE	For expense reports, the receipt currency code (the currency in which the expenses originally occurred).
RECEIPT_CURRENCY_AMOUNT	For expense reports, the receipt currency amount. For all the other rows, this value is null.
RECEIPT_EXCHANGE_RATE	For expense reports, the exchange rate to convert from the receipt currency to the transaction currency.
DENOM_CURRENCY_CODE	The transaction currency code.
DENOM_RAW_COST	The transaction currency raw cost amount of the project-related commitment distribution.
CMT_DISTRIBUTION_ID	The identifier of the requisition or purchase order distribution.
DENOM_BURDENED_COST	The transaction currency burdened cost amount of the project-related commitment distribution.
ACCT_CURRENCY_CODE	The functional currency code.
ACCT_RAW_COST	The functional currency raw cost amount of the project-related commitment distribution.
ACCT_BURDENED_COST	The functional currency burdened cost amount of the project-related commitment distribution.
ACCT_RATE_DATE	The functional currency rate date.
ACCT_RATE_TYPE	The functional currency rate type (such as Spot or Corporate).
ACCT_EXCHANGE_RATE	The functional currency exchange rate.
DESCRIPTION	The description of either the requisition or purchase order line or the invoice distribution.
PROJECT_CURRENCY_CODE	The project currency code.
PROJECT_RATE_DATE	The project currency rate date.
PROJECT_RATE_TYPE	The project currency rate type (such as Spot or Corporate).
PROJECT_EXCHANGE_RATE	The project currency exchange rate.
CMT_REJECTION_CODE	The reason why the item was rejected during commitments summarization.
GENERATION_ERROR_FLAG	Flag that indicates whether the item has encountered errors during commitments summarization. If Errors, this flag is set to Y.
INVENTORY_ITEM_ID	Identifier for inventory item
BOM_LABOR_RESOURCE_ID	Identifier for BOM labor resource
BOM_EQUIPMENT_RESOURCE_ID	Identifier for BOM equipment resource
PROJ_RAW_COST	Project raw cost amount
PROJ_BURDENED_COST	Project burdened cost amount
PROJ_CURRENCY_CODE	Project currency code
PROJ_RATE_DATE	Project rate date
PROJ_RATE_TYPE	Project rate type
PROJ_EXCHANGE_RATE	Project exchange rate
UOM_CODE	Unit of measure code
RESOURCE_CLASS	Holds the code used to identify the resource class.The supported resource class codes are PEOPLE, EQUIPMENT,MATERIAL_ITEMS and FINANCIAL_ELEMENTS.
EXPENDITURE_ITEM_DATE	The expenditure item date on which you expect to incur the commitment costs.
SRC_SYSTEM_LINKAGE_FUNCTION	The system linkage of the source expenditure items which were summarized to create separate burden transaction.

Projects - PA_BUDGETS	10SC Only
Column Name	Descritpion
PROJECT_ID	The identifier of the project for which the budget is defined
READY_TO_BASELINE_FLAG	Flag that indicates whether the DRAFT budget is ready to be baselined. This column is blank for BASELINE and ORIGINAL budgets
BUDGET_TYPE_CODE	The status of the budget
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_BUDGET_ITEMS	10SC Only
Column Name	Descritpion
PROJECT_ID	The identifier of the project subbudget for which the budget item is entered
BUDGET_TYPE_CODE	The status of the subbudget for which the budget item is entered
EXPENDITURE_CATEGORY	The expenditure category for which cost is budgeted
EXPENDITURE_TYPE	The expenditure type for which cost is budgeted
LINE_NUM	The sequential number that identifies the budget item within a subbudget
JOB_ID	The identifier of the job for which cost is budgeted
ORGANIZATION_ID	The identifier of the organization for which cost is budgeted
LAST_UPDATE_DATE	Standard Who Column
REVENUE_CATEGORY	The revenue category for which revenue is budgeted
COST	The budgeted cost for the budget item
LAST_UPDATED_BY	Standard Who Column
REVENUE	The budgeted revenue amount for the budget item
LABOR_HOURS	The budgeted labor hours for the budget item. Labor hours can only be specified for a cost budget item for a labor expenditure type or a job
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
TASK_ID	The identifier of the task subbudget for which the budget item is entered

Projects - PA_BURDEN_COST_MULTIPLIERS	R10SC Only - Multipliers for different types of overhead which are applied to raw cost to calculate burden cost
Column Name	Descritpion
BURDEN_COST_CODE	The burden cost code for which the multiplier is entered
PROJECT_ID	The identifier of the project to which the multiplier is assigned
TASK_ID	The identifier of the task to which the multiplier is assigned
ORGANIZATION_ID	The identifier of the organization to which the multiplier is assigned
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
MULTIPLIER	The multiplier used to determine an item's burden cost. Burden cost = raw cost * ( 1 + multiplier )
START_DATE_ACTIVE	First effective date of the burden cost multiplier
END_DATE_ACTIVE	Last effective date of the burden cost multiplier

Projects - PA_BURDEN_COST_CODES	R10SC Only - Implementation-defined classifications of the different types of overhead burden costs
Column Name	Descritpion
BURDEN_COST_CODE	Name that uniquely identifies the burden cost code
START_DATE_ACTIVE	First effective date of the burden cost code
END_DATE_ACTIVE	Last effective date of the burden cost code
DESCRIPTION	Explanation of the burden cost code
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
MEANING	Short, implementation-defined name that describes the burden cost code
BURDEN_COST_TYPE	The burden cost type that classifies the burden cost code
REVENUE_BUILDUP_FLAG	Flag that indicates whether the burden cost code is used to build up revenue. Project Accounting does not currently use this flag except to use only codes with this flag = 'N' and type = 'Labor' when burdening labor costs

Projects - PA_BILLING_CYCLES	System-defined and implementation-defined billing cycle definitions
Column Name	Descritpion
BILLING_CYCLE_ID	The system generated identifier to uniquely identify a billing cycle
BILLING_VALUE3	Developer descriptive flexfield segment.
BILLING_VALUE4	Developer descriptive flexfield segment.
BILLING_VALUE5	Developer descriptive flexfield segment.
ATTRIBUTE1	Descriptive flexfield segment column.
ATTRIBUTE2	Descriptive flexfield segment column.
ATTRIBUTE3	Descriptive flexfield segment column.
ATTRIBUTE4	Descriptive flexfield segment column.
ATTRIBUTE5	Descriptive flexfield segment column.
ATTRIBUTE6	Descriptive flexfield segment column.
BILLING_CYCLE_NAME	The user defined unique name to identify a billing cycle.
ATTRIBUTE7	Descriptive flexfield segment column.
ATTRIBUTE8	Descriptive flexfield segment column.
ATTRIBUTE9	Descriptive flexfield segment column.
ATTRIBUTE10	Descriptive flexfield segment column.
ATTRIBUTE11	Descriptive flexfield segment column.
ATTRIBUTE12	Descriptive flexfield segment column.
ATTRIBUTE13	Descriptive flexfield segment column.
ATTRIBUTE14	Descriptive flexfield segment column.
ATTRIBUTE15	Descriptive flexfield segment column.
LAST_UPDATE_DATE	Standard WHO Column
BILLING_CYCLE_TYPE	The type of billing cycle.
LAST_UPDATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
CREATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field.
DESCRIPTION	The description of the billing cycle.
START_DATE_ACTIVE	The first effective date of billing cycle.
END_DATE_ACTIVE	The last effective date of billing cycle.
BILLING_ATTRIBUTE_CATEGORY	Developer descriptive flexfield structure defining column.
BILLING_VALUE1	Developer descriptive flexfield segment.
BILLING_VALUE2	Developer descriptive flexfield segment.

Projects - PA_ADW_DIMENSION_STATUS	Dimension status for Oracle Project Analysis Collection Pack
Column Name	Descritpion
DIMENSION_CODE	The Identifier of the dimension for which the status is available
DIMENSION_NAME	The Name of the dimension for which the status is available
STATUS_CODE	Status of the dimension that indicates whether the dimension is enabled or disabled. This column will have a value of 'E' when the dimension is enabled and a value of 'D' when the dimension is disabled.
UPDATE_ALLOWED	This column indicates whether user can disable this dimension or not. If the value of the column is 'N', then user can not disable this dimension.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_ALL_EXP_TYPES_IT	Information about the top level of the standard hierarchy on the expenditure type dimension
Column Name	Descritpion
ALL_EXPENDITURE_TYPES	This column stores the top level dimension value for Standard Hierarchy on Expenditure Type Dimension
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column

Projects - PA_ALL_FINANCIAL_YRS_IT	Information about the top level of the standard hierarchy on the time dimension
Column Name	Descritpion
ALL_FINANCIAL_YEARS	This column stores the top level dimension value for Standard Hierarchy on Time dimension
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column

Projects - PA_ALL_PRJ_TYPES_IT	Information about the top level of the standard hierarchy on the project dimension
Column Name	Descritpion
ALL_PROJECT_TYPES	This column stores the top level dimension value for Standard Hierarchy on Projects Dimension
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column

Projects - PA_ALL_SRVC_TYPES_IT	Information about the top level of the standard hierarchy on the service type dimension
Column Name	Descritpion
ALL_SERVICE_TYPES	This column stores the top level dimension value for Standard Hierarchy on Service Type dimension
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column

Projects - PA_BGT_TYPES_IT	Information about budget types for Oracle Project Analysis Collection Pack
Column Name	Descritpion
BUDGET_TYPE_CODE	The Identifier of the Budget Type used for Oracle Project Analysis Collection Pack
USER_COL4	Column that can be used to store user customizations
USER_COL5	Column that can be used to store user customizations
USER_COL6	Column that can be used to store user customizations
USER_COL7	Column that can be used to store user customizations
USER_COL8	Column that can be used to store user customizations
USER_COL9	Column that can be used to store user customizations
USER_COL10	Column that can be used to store user customizations
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
BUDGET_TYPE	Budget Type of the Budgets used for Oracle Project Analysis Collection Pack
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Columns
CREATED_BY	Standard Who Column
USER_COL1	Column that can be used to store user customizations
USER_COL2	Column that can be used to store user customizations
USER_COL3	Column that can be used to store user customizations

Projects - PA_CLASS_CATGS_IT	Information about class categories for Oracle Project Analysis Collection Pack
Column Name	Descritpion
CLASS_CATEGORY	The Identifier of Class Category used for Oracle Project Analysis Collection Pack
USER_COL4	Column that can be used to store user customizations
USER_COL5	Column that can be used to store user customizations
USER_COL6	Column that can be used to store user customizations
USER_COL7	Column that can be used to store user customizations
USER_COL8	Column that can be used to store user customizations
USER_COL9	Column that can be used to store user customizations
USER_COL10	Column that can be used to store user customizations
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
DESCRIPTION	Description of Class Category used for Oracle Project Analysis Collection Pack
USER_COL1	Column that can be used to store user customizations
USER_COL2	Column that can be used to store user customizations
USER_COL3	Column that can be used to store user customizations

Projects - PA_CLASS_CODES_IT	Information about class codes for Oracle Project Analysis Collection Pack
Column Name	Descritpion
CLASS_CATEGORY	The Identifier for Class Category for which the class code belongs
USER_COL3	Column that can be used to store user customizations
USER_COL4	Column that can be used to store user customizations
USER_COL5	Column that can be used to store user customizations
USER_COL6	Column that can be used to store user customizations
USER_COL7	Column that can be used to store user customizations
USER_COL8	Column that can be used to store user customizations
USER_COL9	Column that can be used to store user customizations
USER_COL10	Column that can be used to store user customizations
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
CLASS_CODE	The class code for the given class category used for Oracle Project Analysis Collection Pack
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS_CODE	The flag that indicates whether this row has any updates or not.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
DESCRIPTION	Description of the class code within the given class category for Oracle Projects Warehouse
USER_COL1	Column that can be used to store user customizations
USER_COL2	Column that can be used to store user customizations

Projects - PA_ALL_ORGANIZATIONS	History information about organizations
Column Name	Descritpion
ORGANIZATION_ID	Identifier of the Organization
ORG_ID	Operating Unit Identifier for multi-organization installations
PA_ORG_USE_TYPE	The purpose for which the organization was used in PA
INACTIVE_DATE	Date on which the organization became inactive in PA. If no date is specified then the organization

Projects - PA_ALLOC_RULES_ALL	Allocation rule definitions
Column Name	Descritpion
RULE_ID	Allocation rule identification number
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DESCRIPTION	Allocation rule description
POOL_PERCENT	Allocation percentage specified at rule leveL
PERIOD_TYPE	Period type of GL (General Ledger) or PA (Oracle Projects)
SOURCE_AMOUNT_TYPE	If the period type is PA, source_amount_type can be ITD or PTD If the period type is GL, source _amount_type can be FYTD, QTD, or PTD
SOURCE_BALANCE_CATEGORY	Source balance category A (Actuals) is only supported
SOURCE_BALANCE_TYPE	Source balance type If the source category is actual, then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST or TOT_BILLABLE_BURDENED_COST
ALLOC_RESOURCE_LIST_ID	Resource List Identifier
RULE_NAME	Allocation rule name
AUTO_RELEASE_FLAG	The flag indicates whether to create expenditure items automatically Y means release automatically
IMP_WITH_EXCEPTION	Default to N Not currently used
DUP_TARGETS_FLAG	The flag indicates whether to allow duplicate target projects and tasksY means to allow duplicate target projects and tasks
OFFSET_EXP_TYPE_CLASS	Expenditure type class of offset transactions
OFFSET_EXP_ORG_ID	Expenditure organization id of offset transactions
OFFSET_EXP_TYPE	Expenditure type of offset transactions
OFFSET_COST_TYPE	Cost type of offset transactions It can be B (burdened) or R (raw)
OFFSET_METHOD	Offset method It can be N (none), A (source project and task), B (source project, use client extension for task), C (specific project and task) or D(use client extension for project and task)
OFFSET_PROJECT_ID	Offset project id
OFFSET_TASK_ID	Offset task id
ALLOCATION_METHOD	Allocation method It can be F (full allocation) or I (incremental allocation)
BASIS_METHOD	Basis method It can be S(spread evenly),P(prorate),C(use client extension basis),FS(target% and spread evenly) or FP(target% and prorate)
BASIS_RELATIVE_PERIOD	Relative basis period
BASIS_AMOUNT_TYPE	If the period type is PA, source_amount_type can be ITD or PTD If the period type is GL, source_amount_type can be FYTD, QTD, or PTD
BASIS_BALANCE_CATEGORY	Basis balance category It can be A (actuals) or B (budgets)
BASIS_BUDGET_TYPE_CODE	Basis budget type code
BASIS_BUDGET_ENTRY_METHOD_CODE	Basis budget entry method code Not in use
BASIS_BALANCE_TYPE	Basis balance type If basis category is actual, then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST, TOT_BILLABLE_BURDENED_COST, TOT_QUANTITY or TOT_LABOR_HOURS If the basis category is budget, then budget
BASIS_RESOURCE_LIST_ID	Basis resource list identifier
SOURCE_EXTN_FLAG	The flag indicates whether source extension exists Y means exist
TARGET_EXTN_FLAG	The flag indicates whether target client extension exists Y means exist
TARGET_EXP_TYPE_CLASS	Expenditure type class of allocation transactions
FIXED_AMOUNT	Fixed source amount
START_DATE_ACTIVE	The date when the rule becomes effective
END_DATE_ACTIVE	The date when the rule becomes ineffective
ORG_ID	Operating unit identifier for multi_organization installations
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
TARGET_EXP_ORG_ID	Expenditure organization of allocation transactions
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
LIMIT_TARGET_PROJECTS_CODE	Business organization level code that limits the selection of target projects
TARGET_EXP_TYPE	Expenditure type of allocation transactions
BASIS_FIN_PLAN_TYPE_ID	Fin plan type populated when allocation basis is Fin Plan
ALLOC_RESOURCE_STRUCT_TYPE	Resource Structure type idendifier for the allocation source resources
BASIS_RESOURCE_STRUCT_TYPE	Resource Structure type idendifier for the allocation basis resources
ALLOC_RBS_VERSION	RBS structure version for allocation source resources.
BASIS_RBS_VERSION	RBS structure version for allocation basis resources.
TARGET_COST_TYPE	Cost type of allocation transactions It can be R(raw) or B (burdened)
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Projects - PA_ACCUM_TXN_TIME	Temporary table used in timing the Refresh Project Summary Amounts process
Column Name	Descritpion
PROJECT_ID	The identifier of the project for which the time statistics are recorded
ATTRIBUTE7	Time statistics attribute 7
ATTRIBUTE8	Time statistics attribute 8
ATTRIBUTE9	Time statistics attribute 9
ATTRIBUTE10	Time statistics attribute 10
ATTRIBUTE11	Time statistics attribute 11
ATTRIBUTE12	Time statistics attribute 12
ATTRIBUTE13	Time statistics attribute 13
ATTRIBUTE14	Time statistics attribute 14
ATTRIBUTE15	Time statistics attribute 15
ATTRIBUTE16	Time statistics attribute 16
PROJECT_NUM	The project number for which the time statistics are recorded
ATTRIBUTE17	Time statistics attribute 17
ATTRIBUTE18	Time statistics attribute 18
ATTRIBUTE19	Time statistics attribute 19
ATTRIBUTE20	Time statistics attribute 20
REQUEST_ID	The identifier of the concurrent request for which the time statistics are recorded
ATTRIBUTE1	Time statistics attribute 1
ATTRIBUTE2	Time statistics attribute 2
ATTRIBUTE3	Time statistics attribute 3
ATTRIBUTE4	Time statistics attribute 4
ATTRIBUTE5	Time statistics attribute 5
ATTRIBUTE6	Time statistics attribute 6

Projects - PA_ALLOC_EXCEPTIONS	Exceptions for an allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
PROJECT_ID	Project ID
TASK_ID	Task ID
EXCEPTION_CODE	Exception code to indicate exceptions
RULE_ID	Allocation rule identification number
LEVEL_CODE	It can be R(rule), S(source), T (target), B (basis) or O(offset)
EXCEPTION_TYPE	Exception type. It can be W(warning) or E(error)
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_ALLOC_GL_LINES	Allocation source lines related to GL accounts
Column Name	Descritpion
RULE_ID	Allocation rule identification number
SOURCE_PERCENT	Percentage of account balance to be considered
LINE_NUM	Line Number of the source line
SOURCE_CCID	Code combination id for GL account
SUBTRACT_FLAG	The flag indicates whether the GL account balance is subtracted. Y means subtracted
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_ALLOC_MISSING_COSTS	Missing costs information for an allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
AMOUNT	Missing amount from project/task
TYPE_CODE	Missing costs type. It can be S(Source),T(Target) or O(Offset)
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PROJECT_ID	Project identification number
TASK_ID	Task identification number

Projects - PA_ALLOC_RESOURCES	Resources and percentages for each allocation rule
Column Name	Descritpion
RULE_ID	Allocation rule identification number
TARGET_EXPND_TYPE	Unused
OFFSET_EXPND_TYPE	Unused
RESOURCE_PERCENTAGE	Percentage of the resource amount to be used for allocation
MEMBER_TYPE	Resource list member type. It can be S(source) or B(basis)
RESOURCE_LIST_MEMBER_ID	Resource list member id
EXCLUDE_FLAG	The flag indicates whether to exclude returned projects
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_ALLOC_RUNS_ALL	Information for allocation runs
Column Name	Descritpion
RUN_ID	Allocation run identification number
LAST_UPDATE_LOGIN	Standard Who Column
FIXED_AMOUNT	Fixed amount
POOL_PERCENT	Allocation percentage specified at rule level
PERIOD_TYPE	Period type of GL (General Ledger) or PA (Oracle Projects)
SOURCE_AMOUNT_TYPE	If the period type is PA , source_amount_type can be ITD or PTD. If the period type is GL, source_amount_type can be FYTD, QTD, or PTD
SOURCE_BALANCE_CATEGORY	Source balance category. It can only be A(actuals)
SOURCE_BALANCE_TYPE	Source balance type. If the source category is actual , then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST or TOT_BILLABLE_BURDENED_COST
ALLOC_RESOURCE_LIST_ID	Resource list member id
AUTO_RELEASE_FLAG	The flag indicates whether to create expenditure items automatically. Y means release automatically
ALLOCATION_METHOD	Allocation method. It can be F(full) or I(incremental)
RULE_ID	Allocation rule identification number
IMP_WITH_EXCEPTION	Default to N. Not currently used
DUP_TARGETS_FLAG	The flag indicates whether to allow duplicate target projects and tasks.Y means to allow duplicate target projects and tasks
TARGET_EXP_TYPE_CLASS	Expenditure type class of allocation transactions
TARGET_EXP_ORG_ID	Expenditure organization of allocation transactions
TARGET_EXP_TYPE	Expenditure type of allocation transactions
TARGET_COST_TYPE	Cost type of allocation transactions. It can be R (raw) or B (burdened)
OFFSET_EXP_TYPE_CLASS	Expenditure type class of offset transactions
OFFSET_EXP_ORG_ID	Expenditure organization id of offset transactions
OFFSET_EXP_TYPE	Expenditure type of offset transactions
OFFSET_COST_TYPE	Cost type of offset transactions. It can be B (burdened) or R (raw)
RUN_PERIOD	Run period name
OFFSET_METHOD	Offset method. It can be N (none) , A (source project and task), B (source project, use client extension for task), C (specific project and task) or D(use client extension for project and task)
OFFSET_PROJECT_ID	Offset project id
OFFSET_TASK_ID	Offset task id
RUN_STATUS	Allocation run status. It can be DF (draft failure) , DS (draft success), RF (release failure), RV (run reverse) or RS (release success)
BASIS_METHOD	Basis method. It can be S(spread evenly) ,P(prorated),C(client extension),FS(fixed and spread evenly) or FP(fixed and prorated)
BASIS_RELATIVE_PERIOD	Relative basis period
BASIS_AMOUNT_TYPE	If the period type is PA , source_amount_type can be ITD or PTD. If the period type is GL, source_amount_type can be FYTD, QTD, or PTD
BASIS_BALANCE_CATEGORY	Basis balance category. it can be A (actuals) or B (budgets)
BASIS_BUDGET_TYPE_CODE	Basis budget type code
BASIS_BUDGET_ENTRY_METHOD_CODE	Basis budget entry method code
EXPND_ITEM_DATE	Expenditure item date for an allocation run
BASIS_BALANCE_TYPE	Basis balance type. If basis category is actual , then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST, TOT_BILLABLE_BURDENED_COST, TOT_QUANTITY or TOT_LABOR_HOURS. If the basis category is budget, then bud
BASIS_RESOURCE_LIST_ID	Basis resource list member id
FISCAL_YEAR	Fiscal year of the run period
QUARTER	Quarter number of the run period
PERIOD_NUM	Period number
TARGET_EXP_GROUP	Target expenditure group name
REV_TARGET_EXP_GROUP	Reversal target expenditure group name
OFFSET_EXP_GROUP	Offset expenditure group name
REV_OFFSET_EXP_GROUP	Reversal offset expenditure group type
TOTAL_POOL_AMOUNT	Total source pool amount
DENOM_CURRENCY_CODE	Denomination currency code
ALLOCATED_AMOUNT	Allocated amount
TOTAL_ALLOCATED_AMOUNT	Total allocated amount
TOTAL_OFFSETTED_AMOUNT	Total offsetted amount
MISSING_SOURCE_PROJ_AMT	Missing source project amount
MISSING_TARGET_PROJ_AMT	Missing target project amount
MISSING_OFFSET_PROJ_AMT	Missing offset project amount
REVERSAL_DATE	Reversal date if the run is reversed
DRAFT_REQUEST_ID	Request id for the draft allocation run
DRAFT_REQUEST_DATE	Creation date of request for a draft allocation
RELEASE_REQUEST_ID	Request id for the release allocation run
CREATION_DATE	Standard Who Column
RELEASE_REQUEST_DATE	Creation date of request for a release allocation
ORG_ID	Operating unit identifier for multi_organization installations
LIMIT_TARGET_PROJECTS_CODE	Buiseness organization level code that limits the selection of target projects.
BASIS_FIN_PLAN_TYPE_ID	Fin plan type populated when allocation basis is Fin Plan
CINT_RATE_NAME	Interest rate name of the Transaction run
ALLOC_RESOURCE_STRUCT_TYPE	Resource Structure type idendifier for the allocation source resource
BASIS_RESOURCE_STRUCT_TYPE	Resource Structure type idendifier for the allocation basis resources
ALLOC_RBS_VERSION	RBS structure version for allocation source resources.
BASIS_RBS_VERSION	RBS structure version for allocation basis resources.
PPL_PROJECT_TYPE
PPL_ORG_ID
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Projects - PA_ALLOC_RUN_BASIS_DET	Basis information for an allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
RESOURCE_LIST_MEMBER_ID	Resource list member id
AMOUNT	Basis Amount
BASIS_PERCENT	Percentage of calculated basis amount in total line amount
LINE_PERCENT	Allocation percentage specified at the target line level
RULE_ID	'Allocation rule identification number
LINE_NUM	Line Number
PROJECT_ID	Project identifier
TASK_ID	Task identifier
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_ALLOC_RUN_GL_DET	Source lines related to GL accounts for each allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
LAST_UPDATE_LOGIN	Standard Who Column
SOURCE_PERCENT	Percentage of account balance to be considered
AMOUNT	Amount
ELIGIBLE_AMOUNT	Eligible_amount=amount*source_percent
RULE_ID	Allocation rule identification number
LINE_NUM	Line Number
SOURCE_CCID	Code combination id for GL account
SUBTRACT_FLAG	The flag indicates whether the GL account balance is subtracted. Y means subtracted
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Projects - PA_ALLOC_RUN_SOURCE_DET	Source project information for each allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
RESOURCE_LIST_MEMBER_ID	Resource list member id
AMOUNT	Amount
RESOURCE_PERCENT	Percentage of allocation at resource line level
ELIGIBLE_AMOUNT	Eligible amount=amount*Resource%
RULE_ID	Allocation rule identification number
LINE_NUM	Line Number of the source line
PROJECT_ID	Project ID
TASK_ID	Task ID
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_ALLOC_RUN_TARGETS	Target projects and tasks for each target line for an allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
LAST_UPDATE_LOGIN	Standard Who Column
TASK_ID	Task ID
LINE_PERCENT	Allocation percentage specified at the target line level
BUDGET_VERSION_ID	Budget versions populated when basis is budget or fin plan
RULE_ID	Allocation rule identification number
LINE_NUM	Line Number of the target line
PROJECT_ID	Project ID
EXCLUDE_FLAG	The flag indicates whether to exclude returned projects. Y means to exclude
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Projects - PA_ALLOC_SOURCE_LINES	Source lines for each allocation rule
Column Name	Descritpion
RULE_ID	Unique identifier for an allocation rule for the source line
TASK_ORG_ID	Task organization id
PROJECT_TYPE	Project type
CLASS_CATEGORY	Class category
CLASS_CODE	Class code
SERVICE_TYPE	Service type
PROJECT_ID	Project id
TASK_ID	Task id
LINE_NUM	Line number
EXCLUDE_FLAG	The flag indicates whether to exclude returned projects Y means exclude
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PROJECT_ORG_ID	Project organization id

Projects - PA_ALLOC_TARGET_LINES	Target lines for each allocation rule
Column Name	Descritpion
RULE_ID	Allocation rule identification number
TASK_ORG_ID	Task organiztation id
PROJECT_TYPE	Project Type
CLASS_CATEGORY	Class Category
CLASS_CODE	Class Code
SERVICE_TYPE	Service type
PROJECT_ID	Project ID
TASK_ID	Task ID
BILLABLE_ONLY_FLAG	The flag indicates whether to pick up billable tasks or all tasks. Y means bill
LINE_PERCENT	Percentage of pool amount assigned to this target line
LINE_NUM	Line Number of the target line
EXCLUDE_FLAG	The flag indicates whether to exclude returned projects. Y means exclude
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PROJECT_ORG_ID	Standard Who Column

Projects - PA_ALLOC_TXN_DETAILS	Transactions created by an allocation run
Column Name	Descritpion
ALLOC_TXN_ID	Allocation transaction id
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PROJECT_ID	Project id
TASK_ID	Task id
EXPENDITURE_TYPE	Expenditure type of transactions
TOTAL_ALLOCATION	Total amount to allocate
PREVIOUS_ALLOCATION	Previous allocation amount
RUN_ID	Allocation run identification number
CURRENT_ALLOCATION	Current allocation amount
REJECTION_CODE	Rejection code to indicate rejections
STATUS_CODE	Transactions status. It can be P (pending),R (rejected) or A (accepted)
EXPENDITURE_ID	Expenditure id when expenditure is created
EXPENDITURE_ITEM_ID	Expenditure item id when expenditure item is created
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
RULE_ID	Allocation rule identification number
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
CINT_SOURCE_TASK_ID	Task identifier from the source transaction
CINT_EXP_ORG_ID	Expenditure Organization Identifier for capitalized interest transactions.
CINT_RATE_MULTIPLIER	Interest rate multiplier used to create the interest transaction
CINT_PRIOR_BASIS_AMT	The summarized prior basis amount used to create the interest transaction.
CINT_CURRENT_BASIS_AMT	The summarized current basis amount used to create the interest transaction.
IND_RATE_SCH_REVISION_ID	Revision Identifier of the Rate Schedule Revision for Capital Interest Rate Schedule Revisions
TRANSACTION_TYPE	Transactions type. It can be T (Allocation) or O(offset)
FISCAL_YEAR	Fiscal year of the run period
QUARTER_NUM	Quarter number of the run period
PERIOD_NUM	Period number
RUN_PERIOD	Run period
LINE_NUM	Line number

Projects - PA_ALLOC_RUN_SOURCES	Source projects and tasks for each source line for an allocation run
Column Name	Descritpion
RUN_ID	Allocation run identification number
LAST_UPDATE_LOGIN	Standard Who Column
TASK_ID	Task id
RULE_ID	Allocation rule identification number
LINE_NUM	Line number of the source line
PROJECT_ID	Project identifier
EXCLUDE_FLAG	The flag indicates whether to exclude returned projects. Y means to exclude
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Projects - PA_BIS_PRJ_BY_PRD_DRILLS_ALL	Actuals and budget amounts by project and period for reporting.
Column Name	Descritpion
DRILLDOWN_TYPE	The type of drilldown associated with the data
END_DATE	The end date for the period
SORT_ORDER	The order in which the data is to be sorted in
ACTUAL	The actual amount column for cost or revenue
BUDGET	The budget amount column Only current versions of approved cost and approved revenue budgets used
ORG_ID	Operating unit identifier for multi-organization installations
AMOUNT_TYPE_CODE	The type of the amount, COST or REVENUE
PROJECT_ID	The identifier of the project
DRILLDOWN_KEY1	The key used for drilldown to the next report
DRILLDOWN_KEY2	The key used for drilldown to the next report
DRILLDOWN_KEY3	The key used for drilldown to the next report
PERIOD_NAME	The period name for the data
ACCUMULATION_PERIOD_TYPE	The type of period for accumulation
START_DATE	The start date for the period

Projects - PA_BIS_PRJ_TO_DATE_DRILLS_ALL	Period and year to date actuals and budget amounts for a project for reporting.
Column Name	Descritpion
DRILLDOWN_TYPE	The type of drilldown associated with the data
ACTUAL_PTD	The period to date values for the actual amount
BUDGET_PTD	The period to date values for the budget amount
ACTUAL_YTD	The year to date values for the actual amount
BUDGET_YTD	The year to date values for the budget amount
ORG_ID	Operating unit identifier for multi-organization installations
AMOUNT_TYPE_CODE	The type of the amount, COST or REVENUE
DRILLDOWN_KEY1	The key used for drilldown to the next report
DRILLDOWN_KEY2	The key used for drilldown to the next report
DRILLDOWN_KEY3	The key used for drilldown to the next report
PROJECT_ID	The identifier of the project
PROJECT_NUMBER	The project number of the project
PROJECT_NAME	The name of the project
SORT_ORDER	The order in which the data is to be sorted in

Projects - PA_BIS_TOTALS_BY_PRD_ALL	Total actuals and budget amounts for reporting.
Column Name	Descritpion
AMOUNT_TYPE_CODE	The type of the amount, COST or REVENUE
PERIOD_NAME	The period name for the data
ACCUMULATION_PERIOD_TYPE	The type of period for accumulation
START_DATE	The start date of the period
END_DATE	The end date of the period
SORT_ORDER	The order in which the data is to be sorted in
ACTUAL	The actual amount column for cost or revenue
BUDGET	The budget amount column Only current versions of approved cost and approved revenue budgets used
ORG_ID	Operating unit identifier for multi-organization installations

Projects - PA_BIS_TOTALS_TO_DATE_ALL	Period and year to date actuals and budget amounts for reporting.
Column Name	Descritpion
AMOUNT_TYPE_CODE	The type of the amount, COST or REVENUE
SORT_ORDER	The order in which the data is to be sorted in
DRILLDOWN_INDICATOR	The flag to indicate if there is nay drill available for this record Values are Y,N
ACTUAL_PTD	The period to date values for the actual amount
BUDGET_PTD	The period to date values for the budget amount
ACTUAL_YTD	The year to date values for the actual amount
BUDGET_YTD	The year to date values for the budget amount
ORG_ID	Operating unit identifier for multi-organization installations

Projects - PA_BIS_TO_DATE_DRILLS_ALL	Period and year to date actuals and budget amounts for reporting.
Column Name	Descritpion
DRILLDOWN_TYPE	The type of drilldown associated with the data
BUDGET_YTD	The year to date values for the budget amount
ORG_ID	Operating unit identifier for multi-organization installations
AMOUNT_TYPE_CODE	The type of the amount, COST or REVENUE
SORT_ORDER	The order in which the data is to be sorted in
DRILLDOWN_KEY1	The key used for drilldown to the next report
DRILLDOWN_KEY2	The key used for drilldown to the next report
DRILLDOWN_KEY3	The key used for drilldown to the next report
ACTUAL_PTD	The period to date values for the actual amount
BUDGET_PTD	The period to date values for the budget amount
ACTUAL_YTD	The year to date values for the actual amount

Projects - PA_BUDGET_LINES_AR	Pa_Budget_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
PURGE_RELEASE	Purge Release
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
RAW_COST_SOURCE
BURDENED_COST_SOURCE
QUANTITY_SOURCE
REVENUE_SOURCE
PM_PRODUCT_CODE
PM_BUDGET_LINE_REFERENCE
PURGE_PROJECT_ID	Purge Project Id
RESOURCE_ASSIGNMENT_ID
START_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
END_DATE
PERIOD_NAME
QUANTITY
BURDENED_COST
RAW_COST
REVENUE
CHANGE_REASON_CODE
DESCRIPTION
ATTRIBUTE_CATEGORY
ATTRIBUTE1

Projects - PA_BUDGET_VERSIONS_AR	Pa_Budget_Versions_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
CURRENT_FLAG
ORIGINAL_FLAG
CURRENT_ORIGINAL_FLAG
PM_BUDGET_REFERENCE
RESOURCE_ACCUMULATED_FLAG
RESOURCE_LIST_ID
PURGE_RELEASE	Purge Release
VERSION_NAME
BUDGET_ENTRY_METHOD_CODE
BASELINED_BY_PERSON_ID
BASELINED_DATE
CHANGE_REASON_CODE
LABOR_QUANTITY
LABOR_UNIT_OF_MEASURE
RAW_COST
BURDENED_COST
REVENUE
PURGE_PROJECT_ID	Purge Project Id
DESCRIPTION
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
BUDGET_VERSION_ID
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
FIRST_BUDGET_PERIOD
PM_PRODUCT_CODE
PROJECT_ID
BUDGET_TYPE_CODE
VERSION_NUMBER
BUDGET_STATUS_CODE
LAST_UPDATE_DATE

Projects - PA_COST_DISTRIBUTION_LINES_AR	Pa_Cost_Distribution_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_BATCH_ID	Identifier of the purge batch in which this record was archived
CREATED_BY
TRANSFER_STATUS_CODE
AMOUNT
QUANTITY
BILLABLE_FLAG
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
PA_DATE
PURGE_RELEASE	Applications release in which this record was archived
DR_CODE_COMBINATION_ID
GL_DATE
TRANSFERRED_DATE
TRANSFER_REJECTION_REASON
BATCH_NAME
ACCUMULATED_FLAG
REVERSED_FLAG
LINE_NUM_REVERSED
SYSTEM_REFERENCE1
SYSTEM_REFERENCE2
PURGE_PROJECT_ID	Project Identifier for this archived record
SYSTEM_REFERENCE3
CR_CODE_COMBINATION_ID
IND_COMPILED_SET_ID
LINE_TYPE
BURDENED_COST
RESOURCE_ACCUMULATED_FLAG
DENOM_CURRENCY_CODE
DENOM_RAW_COST
DENOM_BURDENED_COST
ACCT_CURRENCY_CODE
FUNCTION_TRANSACTION_CODE
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
ACCT_RAW_COST
ACCT_BURDENED_COST
PROJECT_CURRENCY_CODE
PROJECT_RATE_DATE
PROJECT_RATE_TYPE
PROJECT_EXCHANGE_RATE
ORG_ID
CODE_COMBINATION_ID
EXPENDITURE_ITEM_ID
LINE_NUM
CREATION_DATE

Projects - PA_CUST_EVENT_RDL_AR	Pa_Cust_Event_RDL_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
PROJECT_ID	The identifier of the project for which the revenue distribution line is generated. This project is the project for which the event is entered
DRAFT_REVENUE_NUM	The draft revenue number for which the revenue distribution line is generated
DRAFT_REVENUE_ITEM_LINE_NUM	The draft revenue item line number under which the revenue distribution line is generated
CODE_COMBINATION_ID	The identifier of the gl account to which the revenue is charged
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
DRAFT_INVOICE_NUM	The draft invoice number on which the event distribution line is invoiced
DRAFT_INVOICE_ITEM_LINE_NUM	The draft invoice item line number on which the event distribution line is invoiced
PURGE_RELEASE	Purge Release version
BATCH_NAME	The reference to the GL je line in which the revenue was included when posted to GL. This value is a concatenation of the ccid, draft revenue gl date, and transfer request id separated by hyphens. Joins to GL_JE_LINES.REFERENCE_1
LINE_NUM_REVERSED	The distribution line number for the event that is reversed by this distribution line
REVERSED_FLAG	Flag that indicates if the distribution line is reversed by another distribution line
ORG_ID	Operating unit identifier for multi-organization installations
OUTPUT_VAT_TAX_ID	Identifier for default output tax code
OUTPUT_TAX_EXEMPT_FLAG	Standard, Exempt, or required Allows the user to use Standard Exemption rules, force an exemption or require tax to a normally exempt invoice This is defaulted based on user setup
OUTPUT_TAX_EXEMPT_REASON_CODE	Tax Exempt Reason for item lines that have tax_exempt_flag set to (E-exempt)
OUTPUT_TAX_EXEMPT_NUMBER	Exemption Certificate Number for item lines that have tax_exempt_flag set to (E-exempt)
PRC_GENERATED_FLAG	For future use
BILL_TRANS_CURRENCY_CODE	Bill Transaction currency code of the event
BILL_TRANS_AMOUNT	The amount of revenue to accrue for the event in bill transaction currency.
REVPROC_CURRENCY_CODE	Revenue Processing Currency Code
REVPROC_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to revenue processing currency during revenue generation. Currently Project Functional is the Revenue Processing Currency.
PURGE_PROJECT_ID	Purge Project Id
REVPROC_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to Revenue Processing Currency if 'Fixed Date' rate date type used during revenue generation. Currently Project Functional is the Revenue Processing Currency.
REVPROC_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to revenue processing currency. During revenue generation. Currently Project functional currency is the Revenue Processing Currency
INVPROC_CURRENCY_CODE	Invoice Processing Currency
INVPROC_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to project functional currency during revenue generation
INVPROC_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to project functional currency if 'Fixed Date' rate date type used during revenue generation
INVPROC_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to project functional. During revenue generation
PROJECT_CURRENCY_CODE	Project Currency Code
PROJECT_REVENUE_AMOUNT	Revenue Amount in Project Currency
PROJECT_REV_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to project currency during revenue generation
PROJECT_REV_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to project currency if 'Fixed Date' rate date type used during revenue generation
PROJECT_REV_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to project currency during revenue generation
PROJECT_BILL_AMOUNT	Bill Amount in Project Currency. This will be calculated by applying the conversion rules setup for project currency during invoice generation
PROJECT_INV_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to project currency during invoice generation
PROJECT_INV_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to project currency if 'Fixed Date' rate date type used during invoice generation
PROJECT_INV_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to project currency during invoice generation
PROJFUNC_CURRENCY_CODE	Project Functional Currency Code
PROJFUNC_REVENUE_AMOUNT	Revenue Amount in Project Functional Currency
PROJFUNC_REV_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to project functional currency during revenue generation
PROJFUNC_REV_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to project functional currency if 'Fixed Date' rate date type used during revenue generation
PROJFUNC_REV_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to project functional currency during revenue generation
TASK_ID	The identifier of the task that the event is assigned to
PROJFUNC_BILL_AMOUNT	Bill Amount in Project functional Currency. This will be calculated by applying the conversion rules setup for project functional currency during invoice generation
PROJFUNC_INV_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to project functional currency during invoice generation
PROJFUNC_INV_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to project functional currency if 'Fixed Date' rate date type used during invoice generation
PROJFUNC_INV_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to project functional currency during invoice generation
FUNDING_CURRENCY_CODE	Funding Currency Code
FUNDING_REVENUE_AMOUNT	Revenue Amount in Funding Currency
FUNDING_REV_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to funding currency during revenue generation
FUNDING_REV_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to funding currency if 'Fixed Date' rate date type used during revenue generation
FUNDING_REV_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to funding currency during revenue generation
FUNDING_BILL_AMOUNT	Bill Amount in Funding Currency
FUNDING_INV_RATE_TYPE	Exchange rate type to use for conversion between bill transaction currency to project currency during invoice generation
FUNDING_INV_RATE_DATE	Exchange rate date to use for conversion between bill transaction currency to project currency if 'Fixed Date' rate date type used during invoice generation
FUNDING_INV_EXCHANGE_RATE	Exchange rate to be used for conversion between bill transaction currency to project currency during invoice generation
INV_GEN_REJECTION_CODE	Invoice generation rejection code
RETN_DRAFT_INVOICE_NUM	Project invoice number. This will be used to drilldown the retention line from invoice review screen.
RETN_DRAFT_INVOICE_LINE_NUM	Project invoice retention line number. This will be used to drilldown the retention line from invoice review screen.
RETAINED_AMOUNT	Retained amount. This amount is in the invoice processing currency
RETENTION_RULE_ID	The identifier of the retention rule.
OUTPUT_TAX_CLASSIFICATION_CODE	eTax change
EVENT_NUM	The event number of the event that is revenue distributed by the distribution line
LINE_NUM	The sequential number that identifies the revenue distribution line for an event
AMOUNT	The revenue amount to be charged to the GL account for the event on a draft revenue. The amount is stored as a credit
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Projects - PA_CUST_REV_DIST_LINES_AR	Pa_Cust_Rev_Dist_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
DRAFT_REVENUE_NUM
DRAFT_REVENUE_ITEM_LINE_NUM
AMOUNT
CODE_COMBINATION_ID
BILL_AMOUNT
FUNCTION_CODE
FUNCTION_TRANSACTION_CODE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PURGE_RELEASE	Purge Release
PROGRAM_UPDATE_DATE
BATCH_NAME
ADDITIONAL_REVENUE_FLAG
INVOICE_ELIGIBLE_FLAG
DRAFT_INVOICE_NUM
DRAFT_INVOICE_ITEM_LINE_NUM
REVERSED_FLAG
LINE_NUM_REVERSED
REV_IND_COMPILED_SET_ID
INV_IND_COMPILED_SET_ID
PURGE_PROJECT_ID	Purge Project Id
RAW_COST
OUTPUT_VAT_TAX_ID
OUTPUT_TAX_EXEMPT_FLAG
OUTPUT_TAX_EXEMPT_REASON_CODE
OUTPUT_TAX_EXEMPT_NUMBER
ORG_ID
EXPENDITURE_ITEM_ID
LINE_NUM
CREATION_DATE
CREATED_BY
PROJECT_ID

Projects - PA_CC_DIST_LINES_ALL	Information about the accounting distributions related to transfer price for cross charged expenditure items.
Column Name	Descritpion
CC_DIST_LINE_ID	The system-generated number that uniquely identifies the cross charge distribution
REQUEST_ID	Identifier of the concurrent program that last processed the item
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ORG_ID	Identifier of the operating unit to which the cross charge distribution belongs
LINE_NUM_REVERSED	The distribution line number for the same expenditure item that is reversed by this distribution line
DIST_LINE_ID_REVERSED	Identifier of the cross charge distribution that the line reverses .
REVERSED_FLAG	Indicates whether the line has been reversed
EXPENDITURE_ITEM_ID	The identifier of the expenditure item to which the cross charge distribution belongs
DENOM_TP_CURRENCY_CODE	Transaction currency code of the transfer price
DENOM_TRANSFER_PRICE	Transaction amount of the transfer price
ACCT_TP_RATE_TYPE	Rate type used to convert the transfer price amount from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price
ACCT_TP_RATE_DATE	Rate date used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit. Derived from the implementation options currency rate date code for transfer price conversion
ACCT_TP_EXCHANGE_RATE	Exchange rate used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit
DR_CODE_COMBINATION_ID	Identifier of the GL debit account for the distribution
CR_CODE_COMBINATION_ID	Identifier of the GL credit account for the distribution
PA_DATE	The end date of the PA Period in which the distribution was processed. The PA date is determined by the cross charge process from the open or future PA period on or after the expenditure item date
GL_DATE	The end date of the GL accounting period to which the distribution is posted. This date is determined by the transfer program from the first open or future GL period on or after the distributions PA date
GL_BATCH_NAME	The reference to a batch of lines transferred together. This is a concatenation of the liability code combination identifier, GL Date and Transfer request identifier separated by hyphens
LINE_NUM	The sequential line number that identifies the cross charge distribution line for an expenditure item
TRANSFER_STATUS_CODE	The status of the distribution line as the accounting information is transferred to GL.
TRANSFERRED_DATE	The date the record was transferred to GL
TRANSFER_REJECTION_CODE	Rejection code if the record is rejected in transfer to GL.
MARKUP_CALC_BASE_CODE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Transaction amount on which the cross charge rate will be based.
IND_COMPILED_SET_ID	Audit column for transfer price derivation, thus only for borrowed and lent entries. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price.
BILL_RATE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule
TP_BASE_AMOUNT	Audit column for transfer price derivation, thus only for borrowed and lent entries. Base amount used to derive the transfer price, held in transfer price transaction currency
BILL_MARKUP_PERCENTAGE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule
SCHEDULE_LINE_PERCENTAGE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the schedule line
LINE_TYPE	The type of the cross charge distribution line
RULE_PERCENTAGE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the rule definition
REFERENCE_1	The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the Invoice Detail identifier
REFERENCE_2	The reference to a record in another entity in Oracle Projects For Provider reclassification entries, this contains the source of the amount which may be either the raw cost or the burdened cost
PROGRAM_APPLICATION_ID	This column is updated by the program application id when a concurrent program is run.
PROGRAM_ID	This column is updated by the program id when a concurrent program is run.
PROGRAM_UPDATE_DATE	This column is updated by the sysdate when a concurrent program is run.
REFERENCE_3	The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the line number of the corresponding cost distribution line
TP_JOB_ID	Identifies the Job for the transaction for which the Transfer Price is based on.
PROJFUNC_TP_EXCHANGE_RATE	Exchange rate used to convert the transfer price from the transaction currency to the project functional currency.
PROJFUNC_TRANSFER_PRICE	Transfer price in project functional currency.
TP_AMT_TYPE_CODE	Cross charge classification.
PROJFUNC_TP_RATE_TYPE	Rate type used to convert the transfer price from the transaction currency to the project functional currency.
PROJFUNC_TP_RATE_DATE	Rate date used to convert the transfer price from the transaction currency to the project functional currency.
GL_PERIOD_NAME	The GL period in which the transaction is posted.
PA_PERIOD_NAME	The PA period in which the transaction is posted.
PROJECT_TP_CURRENCY_CODE	Project Currency code
PROJECT_TP_RATE_DATE	Rate date used to convert the transfer price from the transaction currency to the project currency.
PROJECT_TP_RATE_TYPE	Rate type used to convert the transfer price from the transaction currency to the project currency.
PROJECT_TP_EXCHANGE_RATE	Exchange rate used to convert the transfer price from the transaction the currency to project currency.
PROJECT_TRANSFER_PRICE	Transfer price in project currency
CROSS_CHARGE_CODE	Indicates the cross charge processing method for the expenditure item.
PROJFUNC_TP_CURRENCY_CODE	Project functional Currency.
ACCT_EVENT_ID	Identifier of Accounting Event
ACCT_SOURCE_CODE	Code used to identify accounting transactions, which are not migrated to SLA
ACCT_CURRENCY_CODE	Functional currency code of the operating unit to which the cross charge distribution belongs
AMOUNT	Amount to be posted to GL in the functional currency. If the line type is Borrowed or Lent, the amount is transfer price. If the line type is Provider Reclass, the amount is raw cost
PROJECT_ID	Identifier of the project to which the expenditure item belongs. Denormalized column
TASK_ID	Identifier of the task to which the expenditure item belongs. Denormalized column

Projects - PA_CC_ORG_RELATIONSHIPS	Information about relationship between operating units and the attributes that specify cross charge control and processing.
Column Name	Descritpion
PRVDR_ORG_ID	The identifier of the provider operating unit
PRVDR_PROJECT_ID	Identifier of the provider project in the provider operating unit to be used for intercompany billing. Populated only if use cross charge processing method of intercompany billing
INVOICE_GROUPING_CODE	Code that indicates if intercompany billing will invoice by cross charged project or by the receiving operating unit Populated only if use cross charge processing method of intercompany billing.
VENDOR_SITE_ID	Identifier of the supplier site for the provider operating unit defined in the receiving operating unit. Populated only if use cross charge processing method of intercompany billing
AP_INV_EXP_TYPE	Expenditure type to be used when creating invoice distribution lines on intercompany payables invoices in the receiver operation unit. Populated only if use cross charge processing method of intercompany billing
AP_INV_EXP_ORGANIZATION_ID	Expenditure organization to be used when creating invoice distribution lines on intercompany payables invoices in the receiver operation unit. Populated only if use cross charge processing method of intercompany billing
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
RECVR_ORG_ID	The identifier of the receiver operating unit
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
PRVDR_ALLOW_CC_FLAG	Indicates whether the provider operating unit can cross charge to projects in the receiver operating unit
ATTRIBUTE15	Descriptive flexfield segment
CROSS_CHARGE_CODE	Type of cross charge processing between the provider and receiver operating units.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_CC_TP_RULES_BG	Rules that define how transfer price is calculated, which include such attributes as calculation method, base amount, schedule or markup, and final percentage.
Column Name	Descritpion
TP_RULE_ID	The system generated number that uniquely identifies the transfer price rule
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
END_DATE_ACTIVE	Last effective date of the transfer price rule
DESCRIPTION	User-defined description of the transfer price rule
BUSINESS_GROUP_ID	The identifier of the business group owning the transfer price rule
SCHEDULE_ID	Identifier of the schedule. Either identifier of the bill rate or burden schedule, depending on the value of the schedule_type
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
NAME	The implementation-defined name that uniquely identifies the transfer price rule within the business group
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
RULE_TYPE	Indicates whether the rule is for labor or non-labor transactions
MARKUP_CALC_BASE_CODE	Transaction amount on which the transfer price will be based when calculated using a markup or burden schedule.
CALC_METHOD_CODE	Method for calculation of the transfer price.
PERCENTAGE_APPLIED	Final percentage applied on the amount derived via the calculation method. Default value is 100%.
START_DATE_ACTIVE	First effective date of the transfer price rule
LAST_UPDATE_DATE	Standard Who Column

Projects - PA_CC_TP_SCHEDULES_BG	Transfer price schedules which define how transfer price is calculated between the provider and receiver organizations for cross charged labor and non-labor transactions.
Column Name	Descritpion
TP_SCHEDULE_ID	The system-generated number that uniquely identifies the transfer price schedule
END_DATE_ACTIVE	Last effective date of the transfer price schedule
DESCRIPTION	Description of the transfer price schedule
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
BUSINESS_GROUP_ID	The identifier of the business group that owns the transfer price schedule
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
NAME	The implementation-defined name that uniquely identifies the transfer price schedule in the business group
START_DATE_ACTIVE	First effective date of the transfer price schedule
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_CC_TP_SCHEDULE_LINES	Transfer price schedule lines which make up a transfer price schedule.
Column Name	Descritpion
TP_SCHEDULE_LINE_ID	The system-generated identifier that uniquely identifies a transfer price schedule line
SORT_ORDER	User defined line number used for ordering. Duplicate values are allowed
LABOR_TP_RULE_ID	The identifier of the transfer price rule for labor transactions. A blank value for this column means that labor transactions are not processed using this schedule line. You must choose either a labor or non-labor transfer price rule for
LABOR_PERCENTAGE_APPLIED	Percentage to be applied for transfer price calculation of labor transactions
NL_TP_RULE_ID	The identifier of the transfer price rule for non-labor transactions. A blank value for this column means that non-labor transactions are not processed using this schedule line. You must choose either a labor or non-labor transfer price ru
NL_PERCENTAGE_APPLIED	Percentage to be applied for transfer price calculation of non-labor transactions
RECVR_ORGANIZATION_ID	Identifier of the receiver organization
END_DATE_ACTIVE	Last effective date of the transfer price schedule line. An organization pair may have many date effective schedule lines but only one effective line for a given date
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
TP_SCHEDULE_ID	The identifier of the transfer price schedule
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
PRVDR_ORGANIZATION_ID	The identifier of the provider organization
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DEFAULT_FLAG	Identifies whether the schedule line is the default for the schedule.
TP_AMT_TYPE_CODE	This indicates Transfer Price Amount type "Cost","Revenue","Cost & Revenue"
START_DATE_ACTIVE	First effective date of the transfer price schedule line. An organization pair may have many date effective schedule lines but only one effective line for a given date
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_CC_TP_SCHEDULE_LINE_LKP	Denormalized data defined for faster processing in finding the transfer price rule between organizations within a transfer price schedule.
Column Name	Descritpion
TP_SCHEDULE_ID	Identifier of the transfer price schedule
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
END_DATE_ACTIVE	Last effective date for the combination of schedule and organizations
LABOR_FLAG	Flag indicates if a rule exists for the labor transaction for the combination of schedule and organizations
TP_AMT_TYPE_CODE	Transfer Price Amount Type code associsted with the Transfer Schedule schedule line.
SORT_ORDER	Sort Order
TP_SCHEDULE_LINE_ID	Identifier of the transfer price schedule line for the combination of schedule and organizations
PRVDR_ORG_ID	Identifier of the provider operating unit
PRVDR_ORGANIZATION_ID	Identifier of the provider organization
RECVR_ORG_ID	Identifier of the receiver operating unit
RECVR_ORGANIZATION_ID	Identifier of the receiver organization
START_DATE_ACTIVE	First effective date for the combination of schedule and organizations
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Projects - PA_AGREEMENTS_EFC
Column Name	Descritpion
SET_OF_BOOKS_ID
AGREEMENT_ID
AMOUNT
ORG_ID
CREATION_DATE

Projects - PA_ALLOC_RUN_BASIS_DET_EFC	PA_ALLOC_RUN_BASIS_DET_EFC archives information before efc switch
Column Name	Descritpion
RUN_ID
LINE_PERCENT
SET_OF_BOOKS_ID
RULE_ID
LINE_NUM
PROJECT_ID
TASK_ID
CREATION_DATE
RESOURCE_LIST_MEMBER_ID
AMOUNT
BASIS_PERCENT

Projects - PA_ALLOC_RUN_GL_DET_EFC
Column Name	Descritpion
RUN_ID
SET_OF_BOOKS_ID
RULE_ID
LINE_NUM
SOURCE_CCID
SUBTRACT_FLAG
CREATION_DATE
SOURCE_PERCENT
AMOUNT
ELIGIBLE_AMOUNT

Projects - PA_ALLOC_RUN_SOURCE_DET_EFC	PA_ALLOC_RUN_SOURCE_DET_EFC archives source information before EFC switch
Column Name	Descritpion
RUN_ID
ELIGIBLE_AMOUNT
SET_OF_BOOKS_ID
RULE_ID
LINE_NUM
PROJECT_ID
TASK_ID
CREATION_DATE
RESOURCE_LIST_MEMBER_ID
AMOUNT
RESOURCE_PERCENT

Projects - PA_ALLOC_TXN_DETAILS_EFC	PA_ALLOC_TXN_DETAILS archives transactions before EFC switch
Column Name	Descritpion
ALLOC_TXN_ID
RUN_ID
RULE_ID
CREATION_DATE
TOTAL_ALLOCATION
PREVIOUS_ALLOCATION
CURRENT_ALLOCATION
SET_OF_BOOKS_ID

Projects - PA_BILLING_ASSIGNMENTS_EFC
Column Name	Descritpion
SET_OF_BOOKS_ID
BILLING_ASSIGNMENT_ID
AMOUNT
ORG_ID
CREATION_DATE

Projects - PA_BILL_RATES_EFC
Column Name	Descritpion
SET_OF_BOOKS_ID
ORG_ID
CREATION_DATE
BILL_RATE_ORGANIZATION_ID
STD_BILL_RATE_SCHEDULE
START_DATE_ACTIVE
PERSON_ID
JOB_ID
EXPENDITURE_TYPE
NON_LABOR_RESOURCE
RATE

Projects - PA_BUDGET_LINES_EFC
Column Name	Descritpion
SET_OF_BOOKS_ID
REVENUE
CHANGE_REASON_CODE
DESCRIPTION
RAW_COST_SOURCE
BURDENED_COST_SOURCE
QUANTITY_SOURCE
REVENUE_SOURCE
PM_PRODUCT_CODE
PM_BUDGET_LINE_REFERENCE
ADJUSTED_EFC_REVENUE_AMT
RESOURCE_ASSIGNMENT_ID
START_DATE
CREATION_DATE
END_DATE
PERIOD_NAME
QUANTITY
RAW_COST
BURDENED_COST

Projects - PA_BUDGET_VERSIONS_EFC
Column Name	Descritpion
SET_OF_BOOKS_ID
CURRENT_ORIGINAL_FLAG
RESOURCE_ACCUMULATED_FLAG
RESOURCE_LIST_ID
VERSION_NAME
BUDGET_ENTRY_METHOD_CODE
BASELINED_BY_PERSON_ID
BASELINED_DATE
CHANGE_REASON_CODE
LABOR_QUANTITY
LABOR_UNIT_OF_MEASURE
BUDGET_VERSION_ID
RAW_COST
BURDENED_COST
REVENUE
DESCRIPTION
FIRST_BUDGET_PERIOD
PM_PRODUCT_CODE
PM_BUDGET_REFERENCE
WF_STATUS_CODE
ADW_NOTIFY_FLAG
ADJUSTED_EFC_REVENUE_AMT
PROJECT_ID
BUDGET_TYPE_CODE
VERSION_NUMBER
BUDGET_STATUS_CODE
CREATION_DATE
CURRENT_FLAG
ORIGINAL_FLAG

Projects - PA_COMMITMENT_TXNS_EFC
Column Name	Descritpion
CMT_LINE_ID
AMOUNT_OUTSTANDING_INVOICE
AMOUNT_OVERBILLED
SET_OF_BOOKS_ID
CREATION_DATE
RECEIPT_CURRENCY_CODE
RECEIPT_CURRENCY_AMOUNT
RECEIPT_EXCHANGE_RATE
DENOM_CURRENCY_CODE
DENOM_RAW_COST
DENOM_BURDENED_COST
TOT_CMT_RAW_COST
ACCT_CURRENCY_CODE
ACCT_RAW_COST
ACCT_BURDENED_COST
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
PROJECT_CURRENCY_CODE
PROJECT_RATE_DATE
PROJECT_RATE_TYPE
PROJECT_EXCHANGE_RATE
TOT_CMT_BURDENED_COST
AMOUNT_ORDERED
ORIGINAL_AMOUNT_ORDERED
AMOUNT_CANCELLED
AMOUNT_DELIVERED
AMOUNT_INVOICED
AMOUNT_OUTSTANDING_DELIVERY

Projects - PA_COMPENSATION_DETAILS_EFC
Column Name	Descritpion
PERSON_ID
START_DATE_ACTIVE
HOURLY_COST_RATE
NCU_SET_OF_BOOKS_ID
CREATION_DATE
END_DATE_ACTIVE
ORG_ID

Projects - PA_ALLOC_MISSING_COSTS_EFC	PA_ALLOC_MISSING_COSTS_EFC archives missing costs information before EFC switch
Column Name	Descritpion
RUN_ID
TYPE_CODE
CREATION_DATE
PROJECT_ID
TASK_ID
AMOUNT
SET_OF_BOOKS_ID

Projects - PA_ALLOC_RULES_ALL_EFC	Table to archive rule information before EFC switch
Column Name	Descritpion
RULE_ID
FIXED_AMOUNT
SET_OF_BOOKS_ID
CREATION_DATE

Projects - PA_ALLOC_RUNS_ALL_EFC
Column Name	Descritpion
RUN_ID
MISSING_SOURCE_PROJ_AMT
MISSING_TARGET_PROJ_AMT
MISSING_OFFSET_PROJ_AMT
SET_OF_BOOKS_ID
RULE_ID
DENOM_CURRENCY_CODE
CREATION_DATE
FIXED_AMOUNT
TOTAL_POOL_AMOUNT
ALLOCATED_AMOUNT
TOTAL_ALLOCATED_AMOUNT
TOTAL_OFFSETTED_AMOUNT

Projects - PA_COST_DIST_LINES_RECVR_EFC	Table containing CDL NCU records prior to EFC switch
Column Name	Descritpion
SET_OF_BOOKS_ID
CREATED_BY
EXPENDITURE_ITEM_ID
LINE_NUM
PROJECT_RAW_COST
PROJECT_BURDENED_COST
PROJECT_CURRENCY_CODE
PROJECT_RATE_DATE
PROJECT_RATE_TYPE
CREATION_DATE

Projects - PA_CONFIG_LISTS	This table was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
Column Name	Descritpion
LIST_ID	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
LAST_UPDATED_BY	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
CREATION_DATE	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
CREATED_BY	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
LAST_UPDATE_LOGIN	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE_CATEGORY	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE1	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE2	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE3	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE4	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE5	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
USER_ID	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE6	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE7	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE8	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE9	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE10	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE11	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE12	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE13	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE14	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
ATTRIBUTE15	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
OBJECT_ID	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
SUBOBJECT_TYPE_CODE	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
LIST_NAME	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
DESCRIPTION	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
DEFAULT_FLAG	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
PUBLIC_FLAG	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
RECORD_VERSION_NUMBER	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.
LAST_UPDATE_DATE	This column was required for Oracle Exchange and is no longer in use for APPS 11.5.9.

Projects - PA_CONFIG_LIST_ELEMENTS	This table stores the defined elements and behaviors of a list, such as the element Id and the display order.
Column Name	Descritpion
LIST_ID	nique system generated number to identify a list
ATTRIBUTE_CATEGORY	Descriptive flexfield content field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LIST_ELEMENT_ID	Identifies the the list element uniquely. In a project list this attribute stores the project_id
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DISPLAY_ORDER	Stores the sort order of displaying the list elements
RECORD_VERSION_NUMBER	Stores the locking sequence number
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column

Projects - PA_COMPETENCE_PROFILES	pa_competence_profiles is a temp table which stores the modified and new inserted competencients for a person until these changes are approved by the manager.
Column Name	Descritpion
PROFILE_ID
DESCRIPTION
RATING_LEVEL_ID
RATING_LEVEL_VALUE
OLD_EFFECTIVE_DATE_FROM
OLD_RATING_LEVEL_ID
OLD_RATING_LEVEL_VALUE
LAST_UPDATED_BY
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
PERSON_ID
OPERATION
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
COMPETENCE_ID
COMPETENCE_ELEMENT_ID
EFFECTIVE_DATE_FROM
COMPETENCE_ALIAS
COMPETENCE_NAME

Projects - PA_ASSIGNMENTS_HISTORY	pa_assignments_history stores details on all approved assignments for a project.
Column Name	Descritpion
ASSIGNMENT_ID	The system-generated number that uniquely identifies the assignment
PROJECT_ROLE_ID	The identifier of the project role for the assignment
RESOURCE_ID	The identifier of the project resource
PROJECT_PARTY_ID	The identifier of the project party on an assignment
DESCRIPTION	The free text description of the assignment
NOTE_TO_APPROVER	The descriptive reason for modification
START_DATE	The start date of the assignment
END_DATE	The end date of the assignment
ASSIGNMENT_EFFORT	Total number of hours of the assignment
EXTENSION_POSSIBLE	Indicates whether it is possible to extend the assignment
SOURCE_ASSIGNMENT_ID	Identifies the requirement from which the assignment record originated
ASSIGNMENT_NAME	The user-defined name that identifies the assignment
ASSIGNMENT_TEMPLATE_ID	The identifier of the requirement template to which this requirement belongs
MIN_RESOURCE_JOB_LEVEL	Indicates the minimum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup.
MAX_RESOURCE_JOB_LEVEL	Indicates the maximum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup.
ASSIGNMENT_NUMBER	A reference number that uniquely identifies a requirement
ADDITIONAL_INFORMATION	The free text for additional information on a assignment
WORK_TYPE_ID	Identifies the type of work being carried out. The default value for this column is retrieved from the project for both requirements and assignments not created from a requirement.
REVENUE_CURRENCY_CODE	Identifies the currency of the override revenue bill rate. The default value is the project currency.
REVENUE_BILL_RATE	The overriding revenue rate for the assignment
EXPENSE_OWNER	The owner of the expenses for the assignment
EXPENSE_LIMIT	The maximum amount that expense owner is willing to pay
ASSIGNMENT_TYPE	Indicates whether it is a assignment
EXPENSE_LIMIT_CURRENCY_CODE	The currency code of the expense limit
FCST_TP_AMOUNT_TYPE	Indicates whether the assignment is classified as cost transfer or revenue transfer for forecasting
FCST_JOB_ID	The identifier for the job for the forecast of the requirement. This column would be used to determine cost, revenue, and transfer price rates for the requirement during forecast processing.
FCST_JOB_GROUP_ID	Indicates the job group associated with the forecasting job. This value defaults from the Team Role.
EXPENDITURE_ORG_ID	Indicates the default operating unit for requirements and assignments. For assignments, this value represents the operating unit of the assigned resource.
EXPENDITURE_ORGANIZATION_ID	Indicates the expenditure organization for the assignment. It defaults to the project organization for requirements and to the resource organization for assignments.
EXPENDITURE_TYPE_CLASS	Identifies the Expenditure Type Class to use to generate forecast transactions. This value defaults from Forecasting Options.
EXPENDITURE_TYPE	Identifies the expenditure type that will be used for this team role for generating forecast transactions. This value defaults from the Forecasting Options.
LOCATION_ID	The identifier of the location of the assignment. The default value for this column on new assignment records is retrieved from the project.
CALENDAR_TYPE	Indicates the base calendar used for generating schedules.
MULTIPLE_STATUS_FLAG	Indicates whether the underlying schedule for the assignment has more than one status
CALENDAR_ID	The identifier of the calendar for the assignment. The default value for this column on new assignment records is retrieved from the project.
RESOURCE_CALENDAR_PERCENT	The percentage of the resource calendar that the resource is allocated on the assignment
PENDING_APPROVAL_FLAG	Indicates whether workflow approval is pending for the assignment
LAST_APPROVED_FLAG	Indicates if the record is the last approved change. If the user decides to revert the last made changes, the record with this flag enabled is used.
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
RECORD_VERSION_NUMBER	Indicates the version of the assignment record. The column increments by one upon each saved modification to the assignment record.
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CHANGE_ID	ID to show the order of the changes made
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
STAFFING_PRIORITY_CODE	The staffing priority of the requirements
PROJECT_SUBTEAM_ID	Identifier of a project subteam on the assignment
NO_OF_ACTIVE_CANDIDATES	Holds the number of candidates with a system status of PENDING_REVIEW or UNDER_REVIEW or SUITABLE.
TEMPLATE_FLAG	Indicates if the requirement is a template requirement.
COMPETENCE_MATCH_WEIGHTING	Indicates the competence match weighting for a requirement
AVAILABILITY_MATCH_WEIGHTING	Indicates the availability match weighting for a requirement
APPRVL_STATUS_CODE	Indicates the approval status of the assignment.
JOB_LEVEL_MATCH_WEIGHTING	Indicates the job level match weighting for a requirement
SEARCH_MIN_AVAILABILITY	The minimum required availability of a resource to be returned in the search result
SEARCH_COUNTRY_CODE	Identifies the country for the search
SEARCH_EXP_ORG_STRUCT_VER_ID	Identifies the organization hierarchy for the search
SEARCH_EXP_START_ORG_ID	Identifies the starting organization for the search
SEARCH_MIN_CANDIDATE_SCORE	The minimum score required for a resource to be nominated as candidate on a requirement
LAST_AUTO_SEARCH_DATE	The most recent date and time when the automated process was run to nominate system generated candidates for the requirement
ENABLE_AUTO_CAND_NOM_FLAG	Indicates whether or not automated candidate nomination for the requirement is enabled
MASS_WF_IN_PROGRESS_FLAG	Indicates whether or not mass workflow processes is pending for this assignment
BILL_RATE_OVERRIDE	The overriding bill rate used to determine the revenue or bill amount for the item
STATUS_CODE	Indicate the schedule status of the assignment. This column may be null if the underlying schedule has multiple status codes.
BILL_RATE_CURR_OVERRIDE	The overriding currency code of the overriding bill rate
MARKUP_PERCENT_OVERRIDE	The overriding markup percentage over raw cost used to determine the revenue or bill amount for the item
TP_RATE_OVERRIDE	The overriding transfer price rate used to determine the cross charge amount of the assignment
TP_CURRENCY_OVERRIDE	The overriding currency code of the overriding transfer price rate
TP_CALC_BASE_CODE_OVERRIDE	The overriding transaction amount on which the transfer price will be based when calculated using applied percentage
TP_PERCENT_APPLIED_OVERRIDE	Identifies the overriding percentage applied on the selected transaction amount to determine the cross charge amount
MARKUP_PERCENT	The markup percent
STAFFING_OWNER_PERSON_ID	Identifier of the staffing owner of the team role
TRANSFER_PRICE_RATE	The transfer price rate of the assignment or requirement
TRANSFER_PR_RATE_CURR	Currency of the transfer price rate
DISCOUNT_PERCENTAGE	Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate.
RATE_DISC_REASON_CODE	Reason code for discount, discount override or rate override.
PROJECT_ID	The identifier of the project to which this assignment belongs

Projects - PA_AMOUNT_TYPES_B	PA_AMOUNT_TYPES_B stores the amount types used in summarization
Column Name	Descritpion
AMOUNT_TYPE_ID	The system generated number that uniquely identifies the amount type
AMOUNT_TYPE_CODE	The amount type code associated with the amount type
AMOUNT_TYPE_CLASS	The amount type class associated with the amount type. Values can be R (raw column) D (derived column)
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PLAN_ADJUSTABLE_FLAG	Indicates that the amount type is an adjustable amount type
PLAN_ADJ_AMOUNT_FLAG	Indicates that the amount type is an adjustment amount type

Projects - PA_AMOUNT_TYPES_TL	PA_AMOUNT_TYPES_TL provides multi-lingual support for amount type names.
Column Name	Descritpion
AMOUNT_TYPE_ID	The system generated number that uniquely identifies the amount type
LANGUAGE	The defined language code for the row's translated columns
SOURCE_LANG	The actual language of the row's translated columns
AMOUNT_TYPE_NAME	The name of the amount type.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Projects - PA_BC_BALANCES	PA_BC_BALANCES stores actual, budget and encumbrance balance per project, task, period, budget version and resource. Budget balances are created during the budget baselining process. Actuals and encumbrances accounting entries are creat
Column Name	Descritpion
PROJECT_ID	Project identifier
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
TOP_TASK_ID	Top task identifier
PARENT_MEMBER_ID	Resource list member of the resource group
REQUEST_ID	Request id of a concurrent program
PROGRAM_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
TASK_ID	Task identifier
PERIOD_NAME	The name of the accounting period in which the balance is created
ACTUAL_PERIOD_TO_DATE	The period-to-date actual amount
BUDGET_PERIOD_TO_DATE	The period-to-date budget amount
ENCUMB_PERIOD_TO_DATE	The period-to-date encumberance amount.
PPL_PROJECT_ID
PTK_TASK_ID
PBN_BUDGET_VERSION_ID
RESOURCE_LIST_MEMBER_ID	Resource list member identifier
SET_OF_BOOKS_ID	Ledger identifier
BUDGET_VERSION_ID	Budget version identifier of the budget for which the balance is created
BALANCE_TYPE	Balance indicates the balance for any of these calegories
START_DATE	The start date of the balance record calculated based on the amount type set in the budgetary controls
END_DATE	The end date of the balance record calculated based on the boundary code set in the budgetary controls
CREATED_BY	Standard Who Column

Projects - PA_BC_COMMITMENTS_ALL	PA_BC_COMMITMENTS holds all the commitment transactions (Req, PO and Payables) that are funds checked. When maintain project balances programs sweeps the commitment records to project balances, the commitments are inserted into this table.
Column Name	Descritpion
BC_COMMITMENT_ID	Unique identifier for a commitment.
JE_CATEGORY_NAME	The journal entry category name
JE_SOURCE_NAME	The journal entry source name
SET_OF_BOOKS_ID	The accounting books identifier.
DOCUMENT_TYPE	Indicates the amount type for any of these categories
EXPENDITURE_ORGANIZATION_ID	Expenditure organization identifier
DOCUMENT_HEADER_ID	Document header identifier
DOCUMENT_DISTRIBUTION_ID	Document distribution identifier
TOP_TASK_ID	Top task identifier
PARENT_RESOURCE_ID	Resource group identifier
PA_DATE	The PA date in which the commitment was funds checked.
PACKET_ID	Budgetary control packet identifier
GL_DATE	The GL date in which the commitment was funds checked.
PROGRAM_ID	This column is updated by the program id when a concurrent program is run
PROGRAM_APPLICATION_ID	This column is updated by the program application id when a concurrent program is run
PROGRAM_UPDATE_DATE	This column is updated by sysdate when a concurrent program is run
TRANSFERRED_DATE	The date when the commitment was transferred to other Oracle Applications
TRANSFER_STATUS_CODE	This is the status of the commitment line when the liquidation entries are transferred to General Ledger. This column is used only for those commitment lines where Burden_Cost_Flag is "O".
PROJECT_BATCH_NAME	Refers to batches of lines transferred together to GL for project budget encumbrance liquidation entries for commitment transactions.
PROJ_TRANSFER_REJ_REASON	Indicates why the project budget encumbrance liquidation entries were rejected by the PA cost transfer program.
PROJ_ENCUMBRANCE_TYPE_ID	Project encumbrance type identifier used during processing.
PROCESS_EXP_ITEM_ID	Temporary expenditure item identifier used during processing.
PROJECT_ID	Project identifier
PROCESS_CCID	Temporary code combination identifier used during processing.
PERIOD_YEAR	The year in the GL period when the transaction was created.
ORG_ID	Operating unit of the commitment.
LIQUIDATE_GL_DATE	Temporary GL date used during processing.
ENCUMBRANCE_TYPE_ID	Commitment encumbrance type identifier used during processing.
COMMITMENT_BATCH_NAME	Refers to batches of lines transferred together to GL for encumbrance liquidation entries for commitment transactions.
COMM_TRANSFER_REJ_REASON	Reason why the commitment encumbrance liquidation entries were rejected by the PA cost transfer program.
BURDEN_COST_FLAG	Temporary flag used during processing to identify burden lines. Valid values are "O", "R" and "N"
RESOURCE_LIST_MEMBER_ID	Resource list member identifier
ENTERED_DR	Transaction debit amount in entered currency
TASK_ID	Task identifier
ENTERED_CR	Transaction credit amount in entered currency
ACCOUNTED_DR	Transaction debit amount in accounting currency
ACCOUNTED_CR	Transaction credit amount in accounting currency
BUDGET_CCID	The account of the budget line to which the commitment was mapped.
TXN_CCID	The account in which the actual / commitment transaction was posted.
BC_PACKET_ID	Budgetary control record identifier
PARENT_BC_PACKET_ID	This column is populated if the transaction is a burden cost. It is populated with the bc packet id of the source.
FUNDS_PROCESS_MODE	Value of this column indicates what processing the record is created for: T => Transaction Processing B => Budget Baselining
BUD_RESOURCE_LIST_MEMBER_ID	Budgeted resource list member identifier
BUD_TASK_ID	Budgeted task identifier
EXPENDITURE_TYPE	Expenditure type for which this transaction was created
REQUEST_ID	Request id for a concurrent program
ACTUAL_FLAG	Indicates the balance type.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DOCUMENT_LINE_ID	Document line identifier
COMPILED_MULTIPLIER	Compiled Burden multiplier
FC_START_DATE	Funds Check Start Date
FC_END_DATE	Funds Check End Date
COMM_TOT_RAW_AMT	Total raw cost for the commitment
COMM_TOT_BD_AMT	Total burden cost for the commitment
COMM_RAW_AMT_RELIEVED	Sum of the commitment raw cost relieved
EXPENDITURE_ITEM_DATE	Date when the transaction was charged
COMM_BD_AMT_RELIEVED	Sum of the commitment burden cost relieved
SUMMARY_RECORD_FLAG	Flag to indicate that the record is summarized by purchase order line, project, task, and expenditure type
EXP_ITEM_ID	Expenditure item identifier
REFERENCE1	Funds check transaction Reference column
REFERENCE2	Funds check transaction Reference column
REFERENCE3	Funds check transaction Reference column
BC_EVENT_ID	Identifier of the budgetary control event
BUDGET_LINE_ID	Identifier of the budget line of the transaction
VENDOR_ID	Identifier of the supplier
BURDEN_METHOD_CODE	Indicates the burden method of the project
DOCUMENT_HEADER_ID_2	Second document header identifieR
DOCUMENT_DISTRIBUTION_TYPE	Document distribution type
PDL_PO_DISTRIBUTION_ID
AIL_DISTRIBUTION_LINE_NUMBER
AIL_INVOICE_ID
PRL_DISTRIBUTION_ID
PCL_LINE_NUM
PCL_EXPENDITURE_ITEM_ID
PERIOD_NAME	The GL period name for which the transaction was created.
PERIOD_NUM	The GL period num for which the transaction was created.
BUDGET_VERSION_ID	Budget version against which this transaction maps

Projects - PA_BC_PACKET_ARRIVAL_ORDER	Keeps track of the processing order of budgetary control packets.
Column Name	Descritpion
PACKET_ID	Budgetary control packet identifier
SET_OF_BOOKS_ID	Accounting Books Identifier
ARRIVAL_SEQ	Budgetary control packet arrival order
AFFECT_FUNDS_FLAG	Affect this packet has on funds availability of later arriving packets.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Projects - PA_BUDGETARY_CONTROL_OPTIONS	pa_budgetary_control_options stores all the default budgetary control levels and time intervals
Column Name	Descritpion
PROJECT_TYPE	Indicates the project type for which the budgetary controls are created.
AMOUNT_TYPE	Indicates how the start date will be calculated using these budgetary control
BOUNDARY_CODE	Indicates how the end date will be calculated using these budgetary control
FUND_CONTROL_LEVEL_PROJECT	The type of funds control for the project level
FUND_CONTROL_LEVEL_TASK	The type of funds control for the task level
FUND_CONTROL_LEVEL_RES_GRP	The type of funds control for the resource group level
FUND_CONTROL_LEVEL_RES	The type of funds control for the resource level
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
PROJECT_ID	Indicates the project Identifier for which these options are set. This should be null when the options are set for a project Type.
LAST_UPDATE_LOGIN	Standard Who Column
YR_END_ROLLOVER_YEAR	Year End Budget Rollover Fiscal Year
YR_END_ROLLOVER_AMOUNT	Year End Budget Rollover Amount
YR_END_ROLLOVER_FLAG	End Rollover Flag. Valid values are S-Success, E-Exception
YR_END_ROLLOVER_MESSAGE	Message code stamped that was occured due to the Year End Budger Rollover Process
REQUEST_ID	Request Id of the concurrent program
PPL_PROJECT_ID
PROJECT_TYPE_ORG_ID	The operating unit of the project type
BUDGET_TYPE_CODE	Budget type to be used for the Budget Integration
BALANCE_TYPE	Indicates the balance type to be used for integration with the Non Project budget.
EXTERNAL_BUDGET_CODE	Specifies the external budget to be used for budget integration. Valid values are GL Budget (GL) , CBC Budget (CC).
GL_BUDGET_VERSION_ID	Specifies the GL Budget to be used if the balance type specified is Budget
ENCUMBRANCE_TYPE_ID	Internal Id that specifies the type of encumbrance to be used for integration if the balance type specified is Encumbrance
BDGT_CNTRL_FLAG	Specifies if this budget type is to be used for project budgetary controls. Valid values are Yes (Y) or No (N)

Projects - PA_BUDGET_ACCT_LINES	This entity stores consolidated accounting information for a budget version.
Column Name	Descritpion
BUDGET_ACCT_LINE_ID	The system generated number that uniquely identifies the Budget Accounting lines
CURR_VER_AVAILABLE_AMOUNT	Available amount of the account for the current baselined/draft budget version. The previous version available amount is equal to the previous budgeted amount minus the amount consumed by the project transactions.
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ACCOUNTED_AMOUNT	The Accounted Amount is the difference between the current and the previous available amount. This amount is funds checked and reserved against GL/CBC budget.
FUNDS_CHECK_STATUS_CODE	Status of the funds checks done for the account against the GL/CBC Budget
FUNDS_CHECK_RESULT_CODE	The result code for the funds checks for the account
REQUEST_ID	Request ID
ID
BUDGET_VERSION_ID	The identifier of the Budget Version for which the Budget Accounting lines are created
GL_PERIOD_NAME	The name of the GL Period Name in which this Budget Accounting line is posted
START_DATE	Start date of the GL period
END_DATE	End date of the GL period
CODE_COMBINATION_ID	Identifier of the Account for the budget line
PREV_VER_BUDGET_AMOUNT	Budgeted amount of the account for the previously baselined budget version
PREV_VER_AVAILABLE_AMOUNT	Available amount of the account for the previously baselined budget version. The previous version available amount is equal to the previous budgeted amount minus the amount consumed by the project transactions.
CURR_VER_BUDGET_AMOUNT	Budgeted amount of the account for the current baselined/draft budget version

Projects - PA_BUDGETARY_CONTROLS	PA_BUDGETARY_CONTROLS are used to store the controls levels that are used to regulate how the funds are reserved for transactions
Column Name	Descritpion
BUDGETARY_CONTROLS_ID	Unique identifier for a budgetary control
TOP_TASK_ID	Top Task identifier
TASK_ID	Task identifier
PARENT_MEMBER_ID	Resource list member identifier of the resource group
RESOURCE_LIST_MEMBER_ID	Resource list member identifier
PRR_RESOURCE_LIST_MEMBER_ID
PTK_TASK_ID
PPL_PROJECT_ID
PROJECT_ID	Project identifier
FUNDS_CONTROL_LEVEL_CODE	Funds control level code identified by this budgetary control
BUDGET_TYPE_CODE	The type of budget
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Projects - PA_BC_PACKETS	PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attributes of a transaction in addition to some other attribute values which are derived before they are p
Column Name	Descritpion
PACKET_ID	Budgetary control packet identifier
DOCUMENT_TYPE	Indicates the amount type for any of these categories
SUMMARY_RECORD_FLAG	Flag to indicate that the record is summarized by purchase order line, project, task, and expenditure type
EXP_ITEM_ID	Expenditure item identifier
REFERENCE1	Funds check transaction Reference column
REFERENCE2	Funds check transaction Reference column
REFERENCE3	Funds check transaction Reference column
FUNDS_PROCESSING_SEQ	Funds processing sequence
TXN_INTERFACE_ID	Transaction Interfaced Identifier
BC_EVENT_ID	Identifier of the budgetary control event
SESSION_ID	Identifier of user session
SERIAL_ID	Identifier of the serial number of the session
BUDGET_LINE_ID	Identifier of the budget line of the transaction
VENDOR_ID	Identifier of the supplier
BURDEN_METHOD_CODE	Indicates the burden method of the project
MAIN_OR_BACKING_CODE	Identifies whether the transaction is a main transaction or a reversal
SOURCE_EVENT_ID	Identifier of the source event
DOCUMENT_HEADER_ID_2	Second document header identifieR
DOCUMENT_DISTRIBUTION_TYPE	Document distribution type
FUNDS_PROCESS_MODE	Indicates what type of processing the record is created for: T => Transaction Processing B => Budget Baselining
EXPENDITURE_ORGANIZATION_ID	Expenditure organization identifier
DOCUMENT_HEADER_ID	Document header identifier.
DOCUMENT_DISTRIBUTION_ID	Document distribution identifier
BUDGET_VERSION_ID	The budget version to which this transaction maps.
BURDEN_COST_FLAG	Temporary flag used during processing to identify burden lines. Valid values are "O", "R" and "N"
BC_PACKET_ID	Budget control record identifier
BALANCE_POSTED_FLAG	Flag indicating whether the transaction posted to the project balances
ACTUAL_FLAG	Indicates the balance type: A => Actual E => Encumbrance
PROJECT_ID	Project identifier
GL_DATE	The end date of the GL period in which the costs were posted.
PA_DATE	The end date of the PA period in which the costs were posted.
PERIOD_NAME	The name of the accounting period in which the transaction was created
PERIOD_YEAR	The year in the accounting period when the transaction was created
PERIOD_NUM	The number of the accounting period in which the transaction was created
BC_COMMITMENT_ID	The unique identifier of the commitment when it was copied into this table.
ENCUMBRANCE_TYPE_ID	Commitment encumbrance type identifier used during processing
PROJ_ENCUMBRANCE_TYPE_ID	Project encumbrance type identifier used during processing.
TOP_TASK_ID	Top task identifier
PARENT_RESOURCE_ID	Resource group identifier
TASK_ID	Task identifier
RESOURCE_LIST_MEMBER_ID	Resource list member identifier
ENTERED_DR	Transaction debit amount in entered currency
ENTERED_CR	Transaction credit amount in entered currency
ACCOUNTED_DR	Transaction debit amount in accounting currency
ACCOUNTED_CR	Transaction credit amount in accounting currency
EFFECT_ON_FUNDS_CODE	Increasing or decreasing effect of the transaction on the funds available.
RESULT_CODE	Result of the funds check or reservation.
TASK_BUDGET_POSTED	Budget amount for the task posted to the project balances.
TASK_ENC_POSTED	Encumbrance amount for the task posted to the project balances
TASK_ENC_APPROVED	Encumbrance amount approved for the task.
EXPENDITURE_TYPE	Expenditure type for which this transaction was created
TASK_ACTUAL_POSTED	Actual amount for the task posted to the project balances.
TASK_ACTUAL_APPROVED	Actual amount approved for the task.
TASK_RESULT_CODE	The result code of the funds check at the task level.
RES_GRP_BUDGET_POSTED	Budget amount for the resource group posted to the project balances
RES_GRP_ENC_POSTED	Encumbrance amount for the resource group posted to the project balances
RES_GRP_ENC_APPROVED	Encumbrance amount approved for the resource group.
RES_GRP_ACTUAL_POSTED	Actual amount for the resource group posted to the project balances
RES_GRP_ACTUAL_APPROVED	Actual amount approved for the resource group.
RES_GRP_RESULT_CODE	The result code of the funds check at the resource group level.
RES_BUDGET_POSTED	Budget amount at the resource level posted to the project balances.
EXPENDITURE_ITEM_DATE	Date for which the transaction was charged
RES_ENC_POSTED	Encumbrance amount for the resource posted to the project balances.
RES_ENC_APPROVED	Encumbrance amount approved at the resource level.
RES_ACTUAL_POSTED	Actual amount at the resource level posted to the project balances
RES_ACTUAL_APPROVED	Actual amount approved at the resource level.
RES_RESULT_CODE	The result code of the funds check at the resource level.
RES_BUDGET_BAL	Budget balance at the resource level after funds check
RES_GRP_BUDGET_BAL	Budget balance at the resource group level after funds check.
TASK_BUDGET_BAL	Budget balance at the task level after funds check.
TOP_TASK_BUDGET_BAL	Budget balance at the top task level after funds check.
PROJECT_BUDGET_BAL	Project level budget balance after funds check
SET_OF_BOOKS_ID	Ledger identifier in General Ledger.
GL_ROW_NUMBER	Value of the row id in GL_BC_PACKETS when the record is copied from GL_BC_PACKETS.
PARENT_BC_PACKET_ID	This column is populated if the transaction is a burden cost. It is populated with the bc packet id of the source.
BUD_RESOURCE_LIST_MEMBER_ID	Budgeted resource list member identifier
BUD_TASK_ID	Budgeted task identifier
R_FUNDS_CONTROL_LEVEL_CODE	Funds control level at resource level.
RG_FUNDS_CONTROL_LEVEL_CODE	Funds control level at resource group level.
T_FUNDS_CONTROL_LEVEL_CODE	Funds control level at task level.
TT_FUNDS_CONTROL_LEVEL_CODE	Funds control level at top task level. This value is based on lookup type
P_FUNDS_CONTROL_LEVEL_CODE	Funds control level at project level. This value is based on lookup type
TOP_TASK_BUDGET_POSTED	Budget amount for the top task posted to the project balances
JE_CATEGORY_NAME	Journal entry category name
TOP_TASK_ENC_POSTED	The amount of the task encumbrance posted to the project balances
TOP_TASK_ENC_APPROVED	Encumbrance amount approved for the top task.
TOP_TASK_ACTUAL_POSTED	Actual amount for the top task posted to the project balances
TOP_TASK_ACTUAL_APPROVED	Actual amount approved for the top task.
TOP_TASK_RESULT_CODE	The result code of the funds check at the top task level.
PROJECT_BUDGET_POSTED	Budget amount for the project posted to the project balances
PROJECT_ENC_POSTED	Encumbrance amount for the project posted to the project balances
PROJECT_ENC_APPROVED	Encumbrance amount approved for the project.
PROJECT_ACTUAL_POSTED	Actual amount for the project posted to the project balances.
PROJECT_ACTUAL_APPROVED	Actual amount approved for the project.
JE_SOURCE_NAME	Journal entry source name
PROJECT_RESULT_CODE	The result code of the funds check at the project level.
PROJECT_ACCT_RESULT_CODE	The result code of the funds check at the project level for each account if the Projects budget is integrated to an external budget.
REQUEST_ID	Request identifier for a concurrent program
BUDGET_CCID	The account of the budget line to which the commitment was mapped.
OLD_BUDGET_CCID	The account of the budget line to which the commitment was mapped.
TXN_CCID	The account in which the actual / commitment transaction was posted.
ORG_ID	The operating unit in which this transaction was created.
ENCUMBRANCE_AMOUNT	The encumbrance amount
PROGRAM_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
STATUS_CODE	Funds check or reservation status. The valid values are based on lookup type
PROGRAM_UPDATE_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DOCUMENT_LINE_ID	Document line identifier
COMPILED_MULTIPLIER	Compiled Burden multiplier
FC_START_DATE	Funds Check Start Date
FC_END_DATE	Funds Check End Date
EXT_BDGT_FLAG	Flag that indicates whether the project budget is linked to an external budget
COMM_TOT_RAW_AMT	Total raw cost for the commitment
COMM_TOT_BD_AMT	Total burden cost for the commitment
COMM_RAW_AMT_RELIEVED	Sum of the commitment raw cost relieved
COMM_BD_AMT_RELIEVED	Sum of the commitment burden cost relieved

Projects - PA_CANDIDATE_REVIEWS	The PA_CANDIDATE_REVIEWS table contains the assignment review log of candidates.
Column Name	Descritpion
CANDIDATE_REVIEW_ID	System generated identifier for the candidate review record
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
CANDIDATE_ID	The identifier for the candidate
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
RECORD_VERSION_NUMBER	Indicates the version of the candidate review record.
STATUS_CODE	Indicates the current status of the candidate
REVIEWER_PERSON_ID	The Person ID of the reviewer
REVIEW_DATE	Date the candidate was reviewed
CHANGE_REASON_CODE	The reason a change in status is made
REVIEW_COMMENTS	Review comments
ATTRIBUTE_CATEGORY	Descriptive flexfield context field

Projects - PA_CANDIDATES	The PA_CANDIDATES table contains candidates for a requirement.
Column Name	Descritpion
CANDIDATE_ID	System-generated number that uniquely identifies the candidate
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ASSIGNMENT_ID	Identifier of the assignment or requirement
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
RESOURCE_ID	The identifier of the resource
LAST_UPDATE_LOGIN	Standard Who Column
RECORD_VERSION_NUMBER	Indicates the version of the candidate record. The column increments by one upon each saved modification to the candidate record.
STATUS_CODE	Indidates the status of the candidate
NOMINATED_BY_PERSON_ID	Person ID of the nominator
NOMINATION_DATE	Nomination date of the candidate
NOMINATION_COMMENTS	Comments by the nominator for nominating the candidate
CANDIDATE_RANKING	Ranking of the candidate with respect to other candidates for the same assignment

Projects - PA_ACTION_SETS	PA_ACTION_SETS stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc
Column Name	Descritpion
ACTION_SET_NAME	Name of the action set. Must be unique within an action_set_type.
ATTRIBUTE5	DFF Column
ATTRIBUTE6	DFF Column
ATTRIBUTE7	DFF Column
ATTRIBUTE8	DFF Column
ATTRIBUTE9	DFF Column
ATTRIBUTE10	DFF Column
ATTRIBUTE11	DFF Column
ATTRIBUTE12	DFF Column
ATTRIBUTE13	DFF Column
ATTRIBUTE14	DFF Column
ACTION_SET_TYPE_CODE	Type of action set. Possible values are Advertisement, Progress Report reminder, etc
ATTRIBUTE15	DFF Column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_TYPE	The object type to which this action set line belongs. Not populated for action set templates.
OBJECT_ID	The object id to which this action set line belongs. Not populated for action set templates.
START_DATE_ACTIVE	Start date of the action set. Only populated for action set templates.
END_DATE_ACTIVE	End date of the action set. Only populated for action set templates.
ACTUAL_START_DATE	Actual start date of the action set. This is the date the status first becomes STARTED. Not populated for action set templates.
DESCRIPTION	Description of the action set template.
ACTION_SET_ID	Unique identifier of an action set.
RECORD_VERSION_NUMBER	Record version number.
SOURCE_ACTION_SET_ID	Action set id of the action set template used to create this action set. Only populated if this action set was created from an action set template.
STATUS_CODE	Indicates the status of the action set. Not currently populated for action set templates.
ACTION_SET_TEMPLATE_FLAG	Indicates if an action set is a template.
MOD_SOURCE_ACTION_SET_FLAG	Indicates if an action set belonging to an object has been modified from the original template.
ATTRIBUTE_CATEGORY	DFF Column
ATTRIBUTE1	DFF Column
ATTRIBUTE2	DFF Column
ATTRIBUTE3	DFF Column
ATTRIBUTE4	DFF Column

Projects - PA_ACTION_SET_LINES	PA_ACTION_SET_LINES stores action set lines that belong to an action set or an action set template
Column Name	Descritpion
ACTION_SET_ID	Unique identifier of an action set
CREATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
ACTION_SET_LINE_NUMBER	Line number of this action line within the action set. This is the order in which the action will be performed based on the conditions.
STATUS_CODE	Status of the action set line. Possible values are 'PENDING', 'ACTIVE', 'REVERSED', etc
STATUS_CODE	Status of the action set line. Possible values are 'PENDING', 'ACTIVE', 'REVERSED' etc
DESCRIPTION	Status of the action set line. Possible values are 'PENDING', 'ACTIVE', 'REVERSED', etc
RECORD_VERSION_NUMBER	Record version number.
LINE_DELETED_FLAG	Indicates if the line has been deleted, but the line is referenced in the audit table so it can not be physically deleted.
ACTION_CODE	Action code for the action set line. There is a set of action codes for each action set type. For example, for action set type 'Advertisement', the action code may be 'NOTIFY_STAFFING_MANAGER'.
ACTION_ATTRIBUTE1	Action attribute 2. Attribute for the action code.
ACTION_SET_LINE_ID	Unique identifier of an action set line.
ACTION_ATTRIBUTE2	Action attribute 2. Attribute for the action code.
ACTION_ATTRIBUTE3	Action attribute 3. Attribute for the action code.
ACTION_ATTRIBUTE4	Action attribute 4. Attribute for the action code.
ACTION_ATTRIBUTE5	Action attribute 5. Attribute for the action code.
ACTION_ATTRIBUTE6	Action attribute 6. Attribute for the action code.
ACTION_ATTRIBUTE7	Action attribute 7. Attribute for the action code.
ACTION_ATTRIBUTE8	Action attribute 8. Attribute for the action code.
ACTION_ATTRIBUTE9	Action attribute 9. Attribute for the action code.
ACTION_ATTRIBUTE10	Action attribute 10. Attribute for the action code.
CREATION_DATE	Standard WHO Column

Projects - PA_ACTION_SET_LINE_AUD	PA_ACTION_SET LINE_AUD stores audit information for each action set line. Each audit line describes what action has been taken in order to implement the action line. For example, if the Advertising action set is to publish a requirement t
Column Name	Descritpion
OBJECT_TYPE	The object type to which this action set line belongs. Possible values are 'PROJECT', 'PROJECT_TEMPLATE', etc
REQUEST_ID	Concurrent program Who column
PROGRAM_APPLICATION_ID	Concurrent program Who column
PROGRAM_ID	Concurrent program Who column
PROGRAM_UPDATE_DATE	Concurrent program Who column
OBJECT_ID	The object id to which this action set line belongs. Possible values are project_id, assignment_id, etc
ACTION_SET_TYPE_CODE	Type of action set. Possible values are Advertisement, Progress Report Reminder, etc
STATUS_CODE	Status of the audit line
REASON_CODE	Reason for the audit line. Possible values include 'PEFORMED', 'REVERSED'.
ACTION_CODE	Action code for the action set line. There is a set of action codes for each action set type. For example, for action set type 'Advertisement', the action code may be 'NOTIFY_STAFFING_MANAGER'.
AUDIT_DISPLAY_ATTRIBUTE	The display attribute containing information regarding how this action set was performed. For example, for action code 'NOTIFY_STAFFING_MANAGER', audit_attribute would contain the staffing manager's full name.
AUDIT_ATTRIBUTE	The attribute containing information regarding how this action set was performed. For example, for action code 'NOTIFY_STAFFING_MANAGER', audit_attribute would contain the staffing manager's person_id.
ACTION_SET_LINE_ID	Identifier of the action set line associated with this audit line.
ACTION_DATE	Date when the action is performed
ACTIVE_FLAG	Indicates if the action set line is active. 'Y' if the action set line is executed, NOT deleted and NOT reversed. Otherwise, 'N'.
REVERSED_ACTION_SET_LINE_ID	Unique identifier of the action set line this line reverses, if any.
OBJECT_NAME	Name of the object
ENCODED_ERROR_MESSAGE	Error message, if any.
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard who column

Projects - PA_ACTION_SET_LINE_COND	PA_ACTION_SET_LINE_COND stores conditions for an action set line. Each action set line must have at least one condition.
Column Name	Descritpion
ACTION_SET_LINE_CONDITION_ID	Unique identifier of an action set line condition.
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description of the condition.
CONDITION_DATE	Date that the condition evaluates to.
CONDITION_CODE	Condition code for the action set line. For example, for action set type 'Advertisement', the condition code may be 'DAYS_BEFORE_AFTER'.
CONDITION_ATTRIBUTE1	Condition code for the action set line. For example, for action set type 'Advertisement', the condition code may be 'DAYS_BEFORE_AFTER'.
CONDITION_ATTRIBUTE2	Condition attribute2. For example, for condition_code 'DAYS_BEFORE_AFTER', condidtion_attribute2 may be '6'.
CONDITION_ATTRIBUTE3	Condition attribute 3. Attribute for the condition code.
CONDITION_ATTRIBUTE4	Condition attribute 4. Attribute for the condition code.
ACTION_SET_LINE_ID	Unique identifier of an action set line.
CONDITION_ATTRIBUTE5	Condition attribute 5. Attribute for the condition code.
CONDITION_ATTRIBUTE6	Condition attribute 6. Attribute for the condition code.
CONDITION_ATTRIBUTE7	Condition attribute 7. Attribute for the condition code.
CONDITION_ATTRIBUTE8	Condition attribute 8. Attribute for the condition code.
CONDITION_ATTRIBUTE9	Condition attribute 9. Attribute for the condition code.
CONDITION_ATTRIBUTE10	Condition attribute 10. Attribute for the condition code.
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Projects - PA_ACTION_SET_TYPES	PA_ACTION_SET_TYPES stores attributes of action set types
Column Name	Descritpion
ACTION_SET_TYPE_NAME	Name of the Action Set Type. This name will be used to generate the page headings / button labels / tips on generic pages. It should NOT contain the word rule or action set. For example, for action_set_type_code ADVERTISEMENT, the action
OBJECT_TYPE	Object Type to which this action set type belongs.
CONC_PROGRAM_VIEW_NAME	Name of the view that will be used to find the action sets to be performed when the Perfrom Action Sets concurrent program is run. Only module specific business logic can be put in this view. Action Set statuses will be checked by the gen
EDIT_TEMPLATE_SEC_FUNC_CODE	Name of security function used to secure create and edit access to Define Action Set page. If this column is NULL then no security check will be performed.
EDIT_OBJECT_SEC_FUNC_CODE	Name of security function used to secure edit access to action lines belonging to an object. Object is hard-coded as Project in the initial release.
VALIDATE_ACTION_SET_LINE_CALL	Name of API (PackageName.ProcedureName) to call in order to validate an action set line. Almost all validation within a single line should be handled by value set validation, but if not possible then this API should be implemented. If not
ACTION_SET_STARTED_CALL	Name of function (PackageName.FunctionName) to call to determine if the action set should be started by default when an action set is applied to an object. Module-specific business logic should be put in this API. If you always want the a
PERFORM_ACTION_SET_LINE_CALL	Name of API (PackageName.ProcedureName) to call in order to perform an action set line.
ACTION_SET_TYPE_CODE	Identifier of the Action Set Type.
PROCESS_ACTION_SET_CALL	Name of API (PackageName.ProcedureName) to call in order to process an action set. Cross-line validation, as well as updating the line number and condition date should be in this API.
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Projects - PA_ALLOC_RUN_RESOURCE_DET	Transaction table storing Resource List Member details.
Column Name	Descritpion
RUN_ID	Allocation Run Identification Number
MEMBER_TYPE	Resource List member type
RESOURCE_LIST_MEMBER_ID	The Identifier of the resource list member
RESOURCE_PERCENT	Resource Utilization percentage
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
RULE_ID	Allocation Rule Identification Number
LAST_UPDATE_LOGIN	Standard Who column

Projects - PA_ASSIGNMENT_CONFLICT_HIST	PA_ASSIGNMENT_CONFLICT_HIST stores a history of potential conflicts that would be formed by an assignment approval transaction. If an assignment would cause a resource to go over capacity without taking other assignments into account, then
Column Name	Descritpion
CONFLICT_GROUP_ID	Identifies all assignment conflicts in a particular transaction group (single and mass)
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ASSIGNMENT_ID	Identifier of assignment causing conflict
CONFLICT_ASSIGNMENT_ID	Identifier of conflicting assignment
RESOLVE_CONFLICTS_ACTION_CODE	Action chosen for resolving conflicts
INTRA_TXN_CONFLICT_FLAG	Y if the conflicting assignment is also part of the transaction. Otherwise, N
PROCESSED_FLAG	Y if conflict has been resolved using resolve_conflicts_action_code. N if conflict has not been resolved.
SELF_CONFLICT_FLAG	Y if assignment_id = conflict_assignment_id. This would occur if the assignment alone would cause the resource to over capacity.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Projects - PA_CUST_RDL_AR	Pa_Cust_Rev_Dist_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_RELEASE
RAW_COST
REQUEST_ID
REVERSED_FLAG
ADDITIONAL_REVENUE_FLAG
AMOUNT
BATCH_NAME
BILL_AMOUNT
CODE_COMBINATION_ID
CREATED_BY
CREATION_DATE
DRAFT_INVOICE_ITEM_LINE_NUM
DRAFT_INVOICE_NUM
DRAFT_REVENUE_ITEM_LINE_NUM
DRAFT_REVENUE_NUM
EXPENDITURE_ITEM_ID
FUNCTION_CODE
FUNCTION_TRANSACTION_CODE
INVOICE_ELIGIBLE_FLAG
INV_IND_COMPILED_SET_ID
LINE_NUM
LINE_NUM_REVERSED
ORG_ID
OUTPUT_TAX_EXEMPT_FLAG
OUTPUT_TAX_EXEMPT_NUMBER
OUTPUT_TAX_EXEMPT_REASON_CODE
OUTPUT_VAT_TAX_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
PROJECT_ID
PURGE_BATCH_ID
PURGE_PROJECT_ID
REV_IND_COMPILED_SET_ID
PRC_GENERATED_FLAG
BILL_TRANS_CURRENCY_CODE
BILL_TRANS_AMOUNT
BILL_TRANS_BILL_AMOUNT
BILL_RATE
REVPROC_CURRENCY_CODE
REVPROC_RATE_TYPE
REVPROC_RATE_DATE
REVPROC_EXCHANGE_RATE
INVPROC_CURRENCY_CODE
INVPROC_RATE_TYPE
INVPROC_RATE_DATE
INVPROC_EXCHANGE_RATE
PROJECT_CURRENCY_CODE
PROJECT_REVENUE_AMOUNT
PROJECT_REV_RATE_TYPE
PROJECT_REV_RATE_DATE
PROJECT_REV_EXCHANGE_RATE
PROJECT_BILL_AMOUNT
PROJECT_INV_RATE_TYPE
PROJECT_INV_RATE_DATE
PROJECT_INV_EXCHANGE_RATE
PROJFUNC_CURRENCY_CODE
PROJFUNC_REVENUE_AMOUNT
PROJFUNC_REV_RATE_TYPE
PROJFUNC_REV_RATE_DATE
PROJFUNC_REV_EXCHANGE_RATE
PROJFUNC_BILL_AMOUNT
PROJFUNC_INV_RATE_TYPE
PROJFUNC_INV_RATE_DATE
PROJFUNC_INV_EXCHANGE_RATE
FUNDING_CURRENCY_CODE
FUNDING_REVENUE_AMOUNT
FUNDING_REV_RATE_TYPE
FUNDING_REV_RATE_DATE
FUNDING_REV_EXCHANGE_RATE
FUNDING_BILL_AMOUNT
FUNDING_INV_RATE_TYPE
FUNDING_INV_RATE_DATE
FUNDING_INV_EXCHANGE_RATE
LABOR_MULTIPLIER
DISCOUNT_PERCENTAGE
AMOUNT_CALCULATION_CODE
BILL_MARKUP_PERCENTAGE
RATE_SOURCE_ID
INV_GEN_REJECTION_CODE
RETN_DRAFT_INVOICE_NUM
RETN_DRAFT_INVOICE_LINE_NUM
RETAINED_AMOUNT
RETENTION_RULE_ID
RATE_DISC_REASON_CODE	reason code for discount,discount override or rate override
OUTPUT_TAX_CLASSIFICATION_CODE	eTax change

Projects - PA_COST_DIST_LINES_AR	Pa_Cost_Distribution_Lines_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
Column Name	Descritpion
PURGE_BATCH_ID
PURGE_RELEASE
ACCUMULATED_FLAG
CREATED_BY
CREATION_DATE
CR_CODE_COMBINATION_ID
DR_CODE_COMBINATION_ID
EXPENDITURE_ITEM_ID
FUNCTION_TRANSACTION_CODE
GL_DATE
ACCT_CURRENCY_CODE
ACCT_EXCHANGE_RATE
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_RAW_COST
DENOM_BURDENED_COST
DENOM_CURRENCY_CODE
DENOM_RAW_COST
IND_COMPILED_SET_ID
PROJECT_CURRENCY_CODE
PROJECT_EXCHANGE_RATE
PROJECT_RATE_DATE
PROJECT_RATE_TYPE
TASK_ID
LINE_NUM
LINE_NUM_REVERSED
PRC_GENERATED_FLAG
SYSTEM_REFERENCE3
LINE_TYPE
TRANSFERRED_DATE
BUDGET_CCID
ORG_ID
TRANSFER_REJECTION_REASON
RECVR_PA_DATE
TRANSFER_STATUS_CODE
AMOUNT
ENCUMBRANCE_AMOUNT
PA_DATE
BATCH_NAME
PROGRAM_APPLICATION_ID
BURDEN_SUM_SOURCE_RUN_ID
PROJFUNC_COST_EXCHANGE_RATE
RECVR_GL_DATE
REVERSED_FLAG
BILLABLE_FLAG
ENCUMBRANCE_TYPE_ID
PA_PERIOD_NAME
PROGRAM_ID
SYSTEM_REFERENCE1
BURDENED_COST
SYSTEM_REFERENCE2
ENCUM_TRANSFER_REJ_REASON
PROGRAM_UPDATE_DATE
PROJFUNC_COST_RATE_TYPE
PROJECT_RAW_COST
BURDEN_SUM_REJECTION_CODE
PROJFUNC_COST_RATE_DATE
UTIL_SUMMARIZED_FLAG
CODE_COMBINATION_ID
RECVR_PA_PERIOD_NAME
PROJECT_BURDENED_COST
PROJFUNC_CURRENCY_CODE
PURGE_PROJECT_ID
LIQUIDATE_ENCUM_FLAG
PROJECT_ID
SYSTEM_REFERENCE4
ACCT_BURDENED_COST
PJI_SUMMARIZED_FLAG
QUANTITY
WORK_TYPE_ID
REQUEST_ID
ENCUMBRANCE_BATCH_NAME
GL_PERIOD_NAME
RESOURCE_ACCUMULATED_FLAG
RECVR_GL_PERIOD_NAME
ORG_LABOR_SCH_RULE_ID	Identifier for org schedule assignment
COST_RATE_SCH_ID	The identifier of the cost rate schedule used during costing.
DENOM_BURDENED_CHANGE
PROJECT_BURDENED_CHANGE
PROJFUNC_BURDENED_CHANGE
ACCT_BURDENED_CHANGE
PARENT_LINE_NUM
PREV_IND_COMPILED_SET_ID
SI_ASSETS_ADDITION_FLAG
SYSTEM_REFERENCE5
ACCT_EVENT_ID
ACCT_SOURCE_CODE

Projects - PA_ACTION_SETS_AR	PA_ACTION_SETS stores action set templates as well as action sets belonging to an object, such as projects, requirements, etc
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
END_DATE_ACTIVE	End date of the action set. Only populated for action set templates.
ACTUAL_START_DATE	Actual start date of the action set. This is the date the status first becomes STARTED. Not populated for action set templates.
DESCRIPTION	Description of the action set template.
RECORD_VERSION_NUMBER	Record version number.
SOURCE_ACTION_SET_ID	Action set id of the action set template used to create this action set. Only populated if this action set was created from an action set template.
STATUS_CODE	Indicates the status of the action set. Not currently populated for action set templates.
ACTION_SET_TEMPLATE_FLAG	Indicates if an action set is a template.
MOD_SOURCE_ACTION_SET_FLAG	Indicates if an action set belonging to an object has been modified from the original template.
ATTRIBUTE_CATEGORY	DFF Column
ATTRIBUTE1	DFF Column
PURGE_RELEASE	Purge release version
ATTRIBUTE2	DFF Column
ATTRIBUTE3	DFF Column
ATTRIBUTE4	DFF Column
ATTRIBUTE5	DFF Column
ATTRIBUTE6	DFF Column
ATTRIBUTE7	DFF Column
ATTRIBUTE8	DFF Column
ATTRIBUTE9	DFF Column
ATTRIBUTE10	DFF Column
ATTRIBUTE11	DFF Column
PURGE_PROJECT_ID	Purged project Id
ATTRIBUTE12	DFF Column
ATTRIBUTE13	DFF Column
ATTRIBUTE14	DFF Column
ATTRIBUTE15	DFF Column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ACTION_SET_ID	Unique identifier of an action set.
ACTION_SET_NAME	Name of the action set. Must be unique within an action_set_type.
ACTION_SET_TYPE_CODE	Type of action set. Possible values are Advertisement, Progress Report reminder, etc
OBJECT_TYPE	The object type to which this action set line belongs. Not populated for action set templates.
OBJECT_ID	The object id to which this action set line belongs. Not populated for action set templates.
START_DATE_ACTIVE	Start date of the action set. Only populated for action set templates.

Projects - PA_ACTION_SET_LINES_AR	PA_ACTION_SET_LINES stores action set lines that belong to an action set or an action set template
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
LINE_DELETED_FLAG	Indicates if the line has been deleted, but the line is referenced in the audit table so it can not be physically deleted.
ACTION_CODE	Action code for the action set line. There is a set of action codes for each action set type. For example, for action set type 'Advertisement', the action code may be 'NOTIFY_STAFFING_MANAGER'.
ACTION_ATTRIBUTE1	Action attribute 1. Attribute for the action code.
ACTION_ATTRIBUTE2	Action attribute 2. Attribute for the action code.
ACTION_ATTRIBUTE3	Action attribute 3. Attribute for the action code.
ACTION_ATTRIBUTE4	Action attribute 4. Attribute for the action code.
ACTION_ATTRIBUTE5	Action attribute 5. Attribute for the action code.
ACTION_ATTRIBUTE6	Action attribute 6. Attribute for the action code.
ACTION_ATTRIBUTE7	Action attribute 7. Attribute for the action code.
ACTION_ATTRIBUTE8	Action attribute 8. Attribute for the action code.
PURGE_RELEASE	Purge release version
ACTION_ATTRIBUTE9	Action attribute 9. Attribute for the action code.
ACTION_ATTRIBUTE10	Action attribute 10. Attribute for the action code.
CREATION_DATE	Standard WHO Column
CREATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
PURGE_PROJECT_ID	Purged project Id
ACTION_SET_LINE_ID	Unique identifier of an action set line.
ACTION_SET_ID	Unique identifier of an action set
ACTION_SET_LINE_NUMBER	Line number of this action line within the action set. This is the order in which the action will be performed based on the conditions.
STATUS_CODE	Status of the action set line. Possible values are 'PENDING', 'ACTIVE', 'REVERSED', etc
DESCRIPTION	Status of the action set line. Possible values are 'PENDING', 'ACTIVE', 'REVERSED', etc
RECORD_VERSION_NUMBER	Record version number.

Projects - PA_ACTN_SETLN_AUD_AR	PA_ACTION_SET LINE_AUD stores audit information for each action set line. Each audit line describes what action has been taken in order to implement the action line. For example, if the Advertising action set is to publish a requirement t
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
ACTION_CODE	Action code for the action set line. There is a set of action codes for each action set type. For example, for action set type 'Advertisement', the action code may be 'NOTIFY_STAFFING_MANAGER'.
AUDIT_DISPLAY_ATTRIBUTE	The display attribute containing information regarding how this action set was performed. For example, for action code 'NOTIFY_STAFFING_MANAGER', audit_attribute would contain the staffing manager's full name.
AUDIT_ATTRIBUTE	The attribute containing information regarding how this action set was performed. For example, for action code 'NOTIFY_STAFFING_MANAGER', audit_attribute would contain the staffing manager's person_id.
ACTION_DATE	Date when the action is performed
ACTIVE_FLAG	Indicates if the action set line is active. 'Y' if the action set line is executed, NOT deleted and NOT reversed. Otherwise, 'N'.
REVERSED_ACTION_SET_LINE_ID	Unique identifier of the action set line this line reverses, if any.
OBJECT_NAME	Name of the object
ENCODED_ERROR_MESSAGE	Error message, if any.
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
PURGE_RELEASE	Purge release version
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent program Who column
PROGRAM_APPLICATION_ID	Concurrent program Who column
PROGRAM_ID	Concurrent program Who column
PROGRAM_UPDATE_DATE	Concurrent program Who column
PURGE_PROJECT_ID	Purged project Id
ACTION_SET_LINE_ID	Identifier of the action set line associated with this audit line.
OBJECT_TYPE	The object type to which this action set line belongs. Possible values are 'PROJECT', 'PROJECT_TEMPLATE', etc
OBJECT_ID	The object id to which this action set line belongs. Possible values are project_id, assignment_id, etc
ACTION_SET_TYPE_CODE	Type of action set. Possible values are Advertisement, Progress Report Reminder, etc
STATUS_CODE	Status of the audit line
REASON_CODE	Reason for the audit line. Possible values include 'PEFORMED', 'REVERSED'.

Projects - PA_ACTN_SET_LN_COND_AR	PA_ACTION_SET_LINE_COND stores conditions for an action set line. Each action set line must have at least one condition.
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
CONDITION_ATTRIBUTE2	Condition attribute2. For example, for condition_code 'DAYS_BEFORE_AFTER', condidtion_attribute2 may be '6'.
CONDITION_ATTRIBUTE3	Condition attribute 3. Attribute for the condition code.
CONDITION_ATTRIBUTE4	Condition attribute 4. Attribute for the condition code.
CONDITION_ATTRIBUTE5	Condition attribute 5. Attribute for the condition code.
CONDITION_ATTRIBUTE6	Condition attribute 6. Attribute for the condition code.
CONDITION_ATTRIBUTE7	Condition attribute 7. Attribute for the condition code.
CONDITION_ATTRIBUTE8	Condition attribute 8. Attribute for the condition code.
CONDITION_ATTRIBUTE9	Condition attribute 9. Attribute for the condition code.
CONDITION_ATTRIBUTE10	Condition attribute 10. Attribute for the condition code.
CREATION_DATE	Standard Who column
PURGE_RELEASE	Purge release version
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PURGE_PROJECT_ID	Purged project Id
ACTION_SET_LINE_ID	Unique identifier of an action set line.
ACTION_SET_LINE_CONDITION_ID	Unique identifier of an action set line condition.
DESCRIPTION	Description of the condition.
CONDITION_DATE	Date that the condition evaluates to.
CONDITION_CODE	Condition code for the action set line. For example, for action set type 'Advertisement', the condition code may be 'DAYS_BEFORE_AFTER'.
CONDITION_ATTRIBUTE1	Condition code for the action set line. For example, for action set type 'Advertisement', the condition code may be 'DAYS_BEFORE_AFTER'.

Projects - PA_ASGMTS_HSTRY_AR	pa_assignments_history stores details on all approved assignments for a project.
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
APPRVL_STATUS_CODE	Indicates the approval status of the assignment.
STATUS_CODE	Indicate the schedule status of the assignment. This column may be null if the underlying schedule has multiple status codes.
PROJECT_ID	The identifier of the project to which this assignment belongs
PROJECT_ROLE_ID	The identifier of the project role for the assignment
RESOURCE_ID	The identifier of the project resource
PROJECT_PARTY_ID	The identifier of the project party on an assignment
DESCRIPTION	The free text description of the assignment
NOTE_TO_APPROVER	The descriptive reason for modification
START_DATE	The start date of the assignment
END_DATE	The end date of the assignment
PURGE_RELEASE	Purge release version
ASSIGNMENT_EFFORT	Total number of hours of the assignment
EXTENSION_POSSIBLE	Indicates whether it is possible to extend the assignment
SOURCE_ASSIGNMENT_ID	Identifies the requirement from which the assignment record originated
ASSIGNMENT_TEMPLATE_ID	The identifier of the requirement template to which this requirement belongs
MIN_RESOURCE_JOB_LEVEL	Indicates the minimum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup.
MAX_RESOURCE_JOB_LEVEL	Indicates the maximum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup.
ASSIGNMENT_NUMBER	A reference number that uniquely identifies a requirement
ADDITIONAL_INFORMATION	The free text for additional information on a assignment
WORK_TYPE_ID	Identifies the type of work being carried out. The default value for this column is retrieved from the project for both requirements and assignments not created from a requirement.
REVENUE_CURRENCY_CODE	Identifies the currency of the override revenue bill rate. The default value is the project currency.
PURGE_PROJECT_ID	Purged project Id
REVENUE_BILL_RATE	The overriding revenue rate for the assignment
EXPENSE_OWNER	The owner of the expenses for the assignment
EXPENSE_LIMIT	The maximum amount that expense owner is willing to pay
EXPENSE_LIMIT_CURRENCY_CODE	The currency code of the expense limit
FCST_TP_AMOUNT_TYPE	Indicates whether the assignment is classified as cost transfer or revenue transfer for forecasting
FCST_JOB_ID	The identifier for the job for the forecast of the requirement. This column would be used to determine cost, revenue, and transfer price rates for the requirement during forecast processing.
FCST_JOB_GROUP_ID	Indicates the job group associated with the forecasting job. This value defaults from the Team Role.
EXPENDITURE_ORG_ID	Indicates the default operating unit for requirements and assignments. For assignments, this value represents the operating unit of the assigned resource.
EXPENDITURE_ORGANIZATION_ID	Indicates the expenditure organization for the assignment. It defaults to the project organization for requirements and to the resource organization for assignments.
EXPENDITURE_TYPE_CLASS	Identifies the Expenditure Type Class to use to generate forecast transactions. This value defaults from Forecasting Options.
ASSIGNMENT_ID	The system-generated number that uniquely identifies the assignment
EXPENDITURE_TYPE	Identifies the expenditure type that will be used for this team role for generating forecast transactions. This value defaults from the Forecasting Options.
LOCATION_ID	The identifier of the location of the assignment. The default value for this column on new assignment records is retrieved from the project.
CALENDAR_TYPE	Indicates the base calendar used for generating schedules.
CALENDAR_ID	The identifier of the calendar for the assignment. The default value for this column on new assignment records is retrieved from the project.
RESOURCE_CALENDAR_PERCENT	The percentage of the resource calendar that the resource is allocated on the assignment
PENDING_APPROVAL_FLAG	Indicates whether workflow approval is pending for the assignment
LAST_APPROVED_FLAG	Indicates if the record is the last approved change. If the user decides to revert the last made changes, the record with this flag enabled is used.
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ASSIGNMENT_NAME	The user-defined name that identifies the assignment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ASSIGNMENT_TYPE	Indicates whether it is a assignment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
STAFFING_PRIORITY_CODE	The staffing priority of the requirements
PROJECT_SUBTEAM_ID	Identifier of a project subteam on the assignment
MULTIPLE_STATUS_FLAG	Indicates whether the underlying schedule for the assignment has more than one status
NO_OF_ACTIVE_CANDIDATES	Holds the number of candidates with a system status of PENDING_REVIEW or UNDER_REVIEW or SUITABLE.
TEMPLATE_FLAG	Indicates if the requirement is a template requirement.
COMPETENCE_MATCH_WEIGHTING	Competence Match Weighting
AVAILABILITY_MATCH_WEIGHTING	Availability Match Weighting
JOB_LEVEL_MATCH_WEIGHTING	Job Level Match Weighting
SEARCH_MIN_AVAILABILITY	Search Minimum Availability
SEARCH_COUNTRY_CODE	Search Country Code
SEARCH_EXP_ORG_STRUCT_VER_ID	Search Expenditure Organization structure Version Id.
SEARCH_EXP_START_ORG_ID	Search Expenditure Start Organization Id.
SEARCH_MIN_CANDIDATE_SCORE	Search Minimum Canditade Score
RECORD_VERSION_NUMBER	Indicates the version of the assignment record. The column increments by one upon each saved modification to the assignment record.
LAST_AUTO_SEARCH_DATE	Last Auto Search Date
ENABLE_AUTO_CAND_NOM_FLAG	Enable auto cand nom flag
MASS_WF_IN_PROGRESS_FLAG	Mass wf in progress flag
BILL_RATE_OVERRIDE	Bill rate override
BILL_RATE_CURR_OVERRIDE	Bill rate curr override
MARKUP_PERCENT_OVERRIDE	Markup percent override
TP_RATE_OVERRIDE	Transfer Price rate override
TP_CURRENCY_OVERRIDE	Transfer Price currency override
TP_CALC_BASE_CODE_OVERRIDE	Transfer Price calc base code override
TP_PERCENT_APPLIED_OVERRIDE	Transfer Price percent applied override
CHANGE_ID	ID to show the order of the changes made
MARKUP_PERCENT	Markup percent
STAFFING_OWNER_PERSON_ID	Identifier of the staffing owner of the team role
TRANSFER_PRICE_RATE	The transfer price rate of the assignment or requirement
TRANSFER_PR_RATE_CURR	Currency of the transfer price rate
DISCOUNT_PERCENTAGE	Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate.
RATE_DISC_REASON_CODE	Reason code for discount,discount override or rate override.

Projects - PA_ASGMT_CNFLT_HIST_AR	PA_ASSIGNMENT_CONFLICT_HIST stores a history of potential conflicts that would be formed by an assignment approval transaction. If an assignment would cause a resource to go over capacity without taking other assignments into account, then
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
SELF_CONFLICT_FLAG	Y if assignment_id = conflict_assignment_id. This would occur if the assignment alone would cause the resource to over capacity.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
PURGE_RELEASE	Purge release version
PURGE_PROJECT_ID	Purged project Id
CONFLICT_GROUP_ID	Identifies all assignment conflicts in a particular transaction group (single and mass)
ASSIGNMENT_ID	Identifier of assignment causing conflict
CONFLICT_ASSIGNMENT_ID	Identifier of conflicting assignment
RESOLVE_CONFLICTS_ACTION_CODE	Action chosen for resolving conflicts
INTRA_TXN_CONFLICT_FLAG	Y if the conflicting assignment is also part of the transaction. Otherwise, N
PROCESSED_FLAG	Y if conflict has been resolved using resolve_conflicts_action_code. N if conflict has not been resolved.

Projects - PA_BILLING_MESSAGES_AR
Column Name	Descritpion
PURGE_RELEASE	Purge release version
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
PURGE_PROJECT_ID	Purged Project id
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LINE_NUM	If the same Billing Extension inserts several messages in the same call, the line num will be incremented for each message
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
INSERTING_PROCEDURE_NAME	This field contains the name of the procedure that a Client Billing Extension specifies when inserting a message using pb_public.insert_message.
BILLING_ASSIGNMENT_ID	The Billing assignment id of the Billing Extension that inserts the message. The procedure PA supplies populates this value automatically.
PROJECT_ID	The project_id of the project being processed when the Billing Extension inserts the message. This is automatically inserted by the PA procedure.
TASK_ID	The task_id of the project being processed when the Billing Extension inserts the message. This is automatically inserted by the PA procedure.
CALLING_PROCESS	The process (Revenue/Invoice) that is executing when the Billing Extension inserts the message.
CALLING_PLACE	The place in the program that the Billing Extension is called from when the message is inserted
PURGE_BATCH_ID	Purge batch id
REQUEST_ID	Standard Who Column
MESSAGE	The message specified by the Clients Billing Extension when calling pb_public.insert_message
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment

Projects - PA_CANDIDATES_AR	The PA_CANDIDATES table contains candidates for a requirement.
Column Name	Descritpion
PURGE_BATCH_ID	Purge batch Id
PURGE_RELEASE	Purge release version
ASSIGNMENT_ID	Identifier of the assignment or requirement
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
CANDIDATE_ID	System-generated number that uniquely identifies the candidate
CANDIDATE_RANKING	Ranking of the candidate with respect to other candidates for the same assignment
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
NOMINATED_BY_PERSON_ID	Person ID of the nominator
NOMINATION_COMMENTS	Comments by the nominator for nominating the candidate
NOMINATION_DATE	Nomination date of the candidate
PURGE_PROJECT_ID	Purged project Id
RECORD_VERSION_NUMBER	Indicates the version of the candidate record. The column increments by one upon each saved modification to the candidate record.
RESOURCE_ID	The identifier of the resource
STATUS_CODE	Indidates the status of the candidate
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column

Projects - PA_CANDIDATES_REV_AR	The PA_CANDIDATE_REVIEWS table contains the assignment review log of candidates.
Column Name	Descritpion
CANDIDATE_ID	The identifier for the candidate
PURGE_RELEASE	Purge release version
RECORD_VERSION_NUMBER	Indicates the version of the candidate review record.
REVIEWER_PERSON_ID	The Person ID of the reviewer
REVIEW_DATE	Date the candidate was reviewed
STATUS_CODE	Indicates the current status of the candidate
CANDIDATE_REVIEW_ID	System generated identifier for the candidate review record
PURGE_BATCH_ID	Purge batch Id
PURGE_PROJECT_ID	Purged project Id
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
CHANGE_REASON_CODE	The reason a change in status is made
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REVIEW_COMMENTS	Review comments

Projects - PA_CC_DIST_LINES_AR
Column Name	Descritpion
PURGE_RELEASE	Purge release version
LINE_NUM_REVERSED	The distribution line number for the same expenditure item that is reversed by this distribution line
DIST_LINE_ID_REVERSED	Identifier of the cross charge distribution that the line reverses .
REVERSED_FLAG	Indicates whether the line has been reversed
DENOM_TP_CURRENCY_CODE	Transaction currency code of the transfer price
DENOM_TRANSFER_PRICE	Transaction amount of the transfer price
ACCT_TP_RATE_TYPE	Rate type used to convert the transfer price amount from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price
ACCT_TP_RATE_DATE	Rate date used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit. Derived from the implementation options currency rate date code for transfer price conversion
ACCT_TP_EXCHANGE_RATE	Exchange rate used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit
DR_CODE_COMBINATION_ID	Identifier of the GL debit account for the distribution
CR_CODE_COMBINATION_ID	Identifier of the GL credit account for the distribution
PURGE_PROJECT_ID	Purged Project id
PA_DATE	The end date of the PA Period in which the distribution was processed. The PA date is determined by the cross charge process from the open or future PA period on or after the expenditure item date
GL_DATE	The end date of the GL accounting period to which the distribution is posted. This date is determined by the transfer program from the first open or future GL period on or after the distributions PA date
GL_BATCH_NAME	The reference to a batch of lines transferred together. This is a concatenation of the liability code combination identifier, GL Date and Transfer request identifier separated by hyphens
TRANSFER_STATUS_CODE	The status of the distribution line as the accounting information is transferred to GL.
TRANSFERRED_DATE	The date the record was transferred to GL
TRANSFER_REJECTION_CODE	Rejection code if the record is rejected in transfer to GL.
MARKUP_CALC_BASE_CODE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Transaction amount on which the cross charge rate will be based.
IND_COMPILED_SET_ID	Audit column for transfer price derivation, thus only for borrowed and lent entries. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price.
BILL_RATE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule
TP_BASE_AMOUNT	Audit column for transfer price derivation, thus only for borrowed and lent entries. Base amount used to derive the transfer price, held in transfer price transaction currency
CC_DIST_LINE_ID	The system-generated number that uniquely identifies the cross charge distribution
BILL_MARKUP_PERCENTAGE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule
SCHEDULE_LINE_PERCENTAGE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the schedule line
RULE_PERCENTAGE	Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the rule definition
REFERENCE_1	The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the Invoice Detail identifier
REFERENCE_2	The reference to a record in another entity in Oracle Projects For Provider reclassification entries, this contains the source of the amount which may be either the raw cost or the burdened cost
PROGRAM_APPLICATION_ID	This column is updated by the program application id when a concurrent program is run.
PROGRAM_ID	This column is updated by the program id when a concurrent program is run.
PROGRAM_UPDATE_DATE	This column is updated by the sysdate when a concurrent program is run.
REFERENCE_3	The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the line number of the corresponding cost distribution line
TP_JOB_ID	Cross charge id
EXPENDITURE_ITEM_ID	The identifier of the expenditure item to which the cross charge distribution belongs
PROJFUNC_TP_EXCHANGE_RATE	Exchange rate used to convert the transfer price from the transaction currency to the project functional currency.
PROJFUNC_TRANSFER_PRICE	Transfer price in project functional currency.
TP_AMT_TYPE_CODE	Cross charge classification.
PROJFUNC_TP_RATE_TYPE	Rate type used to convert the transfer price from the transaction currency to the project functional currency.
PROJFUNC_TP_RATE_DATE	Rate date used to convert the transfer price from the transaction currency to the project functional currency.
GL_PERIOD_NAME	The GL period in which the transaction is posted.
PA_PERIOD_NAME	The PA period in which the transaction is posted.
PROJECT_TP_CURRENCY_CODE	Project Currency code
PROJECT_TP_RATE_DATE	Rate date used to convert the transfer price from the transaction currency to the project currency.
PROJECT_TP_RATE_TYPE	Rate type used to convert the transfer price from the transaction currency to the project currency.
LINE_NUM	The sequential line number that identifies the cross charge distribution line for an expenditure item
PROJECT_TP_EXCHANGE_RATE	Exchange rate used to convert the transfer price from the transaction the currency to project currency.
PROJECT_TRANSFER_PRICE	Transfer price in project currency
PROJFUNC_TP_CURRENCY_CODE	Project functional Currency.
ACCT_EVENT_ID
ACCT_SOURCE_CODE
LINE_TYPE	The type of the cross charge distribution line
CROSS_CHARGE_CODE	Indicates the cross charge processing method for the expenditure item.
ACCT_CURRENCY_CODE	Functional currency code of the operating unit to which the cross charge distribution belongs
PURGE_BATCH_ID	Purge batch id
AMOUNT	Amount to be posted to GL in the functional currency. If the line type is Borrowed or Lent, the amount is transfer price. If the line type is Provider Reclass, the amount is raw cost
PROJECT_ID	Identifier of the project to which the expenditure item belongs. Denormalized column
TASK_ID	Identifier of the task to which the expenditure item belongs. Denormalized column
REQUEST_ID	Identifier of the concurrent program that last processed the item
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ORG_ID	Identifier of the operating unit to which the cross charge distribution belongs

Projects - PA_CI_ACTIONS	This table stores the action log for each control item. Each entry stores the complete requesting information and response.
Column Name	Descritpion
CI_ACTION_ID	System-generated number that uniquely identifies the control item action
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SIGN_OFF_REQUIRED_FLAG	Flag indicating that the control item can be signed off upon action closure
SIGN_OFF_FLAG	Flag indicating that the control item is signed off
RECORD_VERSION_NUMBER	Number used for record locking in self service applications
DATE_REQUIRED	The date on which the action closure is required
DATE_CLOSED	The date on which the action is closed
SOURCE_CI_ACTION_ID	The identifier of the action originated this action
CI_ID	Identifier of the control item
CI_ACTION_NUMBER	System-generated number that uniquely identifies the action within a control item
STATUS_CODE	The user status code for the action
TYPE_CODE	Lookup code indicating the type of the action
ASSIGNED_TO	The identifier of the person assigned to the action
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Projects - PA_CI_COMMENTS	This table stores all the comments in the action log. A comment can be a requestor, closure or progress comment on an action, or unsolicited comment to the control item. For each action, there will be only one requestor comment and one cl
Column Name	Descritpion
CI_COMMENT_ID	System-generated number that uniquely identifies the control item comment
LAST_UPDATE_LOGIN	Standard Who column
CI_ACTION_ID	The identifier of the action with the comment
CI_ID	Identifier of the control item
TYPE_CODE	The lookup code indicating the type of the comment
COMMENT_TEXT	The comment text
RECORD_VERSION_NUMBER	Number used for record locking in self service applications
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Projects - PA_CI_IMPACTS	This table stores impacts identified for the control item.
Column Name	Descritpion
CI_IMPACT_ID	System-generated number that uniquely identifies the control item impact
RECORD_VERSION_NUMBER	Number used for record locking in self service applications
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CI_ID	The identifier of the control item
IMPACT_TYPE_CODE	The lookup code indicating the impact type
STATUS_CODE	The user status code of the impact
DESCRIPTION	The description of the impact
IMPACTED_TASK_ID	The identifier of the task being impacted
IMPLEMENTATION_DATE	The date on which the impact is implemented
IMPLEMENTED_BY	The identifier of the person who implements the impact
IMPLEMENTATION_COMMENT	The comment on the implementation of the impact

Projects - PA_CI_IMPACT_TYPE_USAGE	This table stores the setup data for all the possible impact types for an control item type or type class. Only one of the two column CI_TYPE_CLASS_CODE and CI_TYPE_ID can be populated
Column Name	Descritpion
CI_IMPACT_TYPE_USAGE_ID	System-generated number that uniquely identifies the control item impact usage
IMPACT_TYPE_CODE	Lookup code indicating the impact type
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CI_TYPE_CLASS_CODE	Lookup code indicating the control item type class
CI_TYPE_ID	The identifier of the control item type
IMPACT_TYPE_CODE_ORDER	This column stores the position at which the impact appears in the Impact Type region.

Projects - PA_CI_SUPPLIER_DETAILS	A new entity PA_CI_SUPPLIER_DETAILS, which stores the details of impact of change orders on Suppliers and Purchase Orders. This entity contains the following attributes
Column Name	Descritpion
CI_TRANSACTION_ID	Unique Identifier for the transaction (Primary Key)
ADJUSTED_CI_TRANSACTION_ID	Identifies the adjusted transactions. It stores the value of ci_transaction_id for merged suppliers
CHANGE_DESCRIPTION	Impact description for supplier
CHANGE_TYPE	Describes the Impact on supplier to raise PO i.e. Create New, Update Existing
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
CHANGE_APPROVER	This column stores the name of the customer who can approve the change request.
AUDIT_HISTORY_NUMBER	This column stores the audit history number of the supplier cost details.
CURRENT_AUDIT_FLAG	The value in this column indicates whether the supplier cost details are current. A value of Y indicates current details.
ORIGINAL_SUPP_TRANS_ID	This column stores the ID of the original supplier transaction from which the transaction is created.
SOURCE_SUPP_TRANS_ID	This column stores the ID of the supplier transaction from which the transaction is created.
CI_ID	Identifier for the control item such as change order, memo, change request.
FROM_CHANGE_DATE	This column stores the date from which the changes due to the impact are effective.
TO_CHANGE_DATE	This column stores the date till which the changes due to the impact are effective.
RAW_COST	This column stores the raw cost in projects functional currency.
BURDENED_COST	This column stores the burden cost in projects functional currency.
REVENUE_RATE	This column stores the existing revenue rate.
REVENUE_OVERRIDE_RATE	This column stores the revenue override rate.
REVENUE	This column stores the revenue in transactional currency.
TOTAL_REVENUE	This column stores the total revenue in projects functional currency.
SUP_QUOTE_REF_NO	This column stores the reference number of the supplier quotation.
TASK_ID	Task for which purchase order raised on given supplier.
RESOURCE_LIST_MEMBER_ID	The planning resource for the supplier cost.
EXPENDITURE_TYPE_ID	Type of expenditure for requested change.
ESTIMATED_COST	Estimated cost of requested change.
QUOTED_COST	Cost quoted by supplier for change.
CI_TYPE_ID	Identifier for the info item type
NEGOTIATED_COST	Negotiated estimated cost of change.
FINAL_COST	Final actual cost of change.
MARKUP_COST	Markup cost of change.
STATUS	Status of supplier cost.
CI_IMPACT_ID	Identifier for the impact
VENDOR_ID	Identifier for the supplier
PO_HEADER_ID	Identifier for the Purchase Order details
PO_LINE_ID	Identifier for the Purchase Order Line details
CHANGE_AMOUNT	Purchase Order Amount
CURRENCY_CODE	Currency details for the Purchase Order amount

Projects - PA_CI_TYPES_B	The table stores the control item type definitions. The values are created by the customer.
Column Name	Descritpion
CI_TYPE_ID	System-generated number that uniquely identifies the control item type
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
START_DATE_ACTIVE	The starting active date for the control item type
END_DATE_ACTIVE	The ending active date for the control item type
LAST_UPDATE_LOGIN	Standard Who column
CLASSIFICATION_CATEGORY	The class category used as list of values for classification
REASON_CATEGORY	The class category used as list of values for reason
RESOLUTION_CATEGORY	The class category used as list of values for resolution type
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
CI_TYPE_CLASS_CODE	Lookup code for the control item type class
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
AUTO_NUMBER_FLAG	Flag indicating that item numbers are system-generated
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
APPROVAL_TYPE_CODE	The value in this column specifies the approval type code required for the control item type.
SUBCONTRACTOR_REPORTING_FLAG	The value in this column determines whether the Subcontract Reporting region is displayed in the Change Management page. To display this region, set the value to Y.
PREFIX_AUTO_NUMBER	This column stores the prefix of the change document number.
IMPACT_BUDGET_TYPE_CODE	The value in this column indicates the budget update method code for the control item type.
COST_COL_FLAG	The value in this column determines whether the Cost column is displayed in the Financial region. A value of Y indicates that the column is displayed.
REV_COL_FLAG	The value in this column determines whether the Revenue column is displayed in the Financial region. A value of Y indicates that the column is displayed.
DIR_COST_REG_FLAG	The value in this column determines whether the Direct Cost sub-region is displayed in the Financial region. A value of Y indicates that the sub-region is displayed.
SUPP_COST_REG_FLAG	The value in this column determines whether the Supplier Cost sub-region is displayed in the Financial region. A value of Y indicates that the sub-region is displayed.
DIR_REG_REV_COL_FLAG	The value in this column determines whether the Revenue column is displayed in the Direct Cost as well as the Supplier cost sub-regions of the Financial region. A value of Y indicates that the column is displayed in both the sub-regions.
RESOLUTION_REQUIRED_FLAG	Flag indicating that a resolution is required for closure of control items associated with this item type
APPROVAL_REQUIRED_FLAG	For Change Orders and Change Requests, this flag indicates auto-approval of the item. For Issues, this flag indicates no approval required.
SOURCE_ATTRS_ENABLED_FLAG	Flag indicating that the source attributes for a control item are made available for entry
ALLOW_ALL_USAGE_FLAG	Flag indicating that all the project types are allowed to use this control item type.
RECORD_VERSION_NUMBER	Number used for record locking in self service applications
LAST_UPDATED_BY	Standard Who column

Projects - PA_CI_TYPES_TL	The table consists of the name and description of a project control item type.
Column Name	Descritpion
CI_TYPE_ID	System-generated number that uniquely identifies the control item type
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	User-defined description of the control item type
NAME	User-defined name of the control item type
SHORT_NAME	User-defined abbreviated name of the control item type
LANGUAGE	The defined language code for the row's translated columns
SOURCE_LANG	Indicates the actual language of the row's translated columns
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Projects - PA_CI_TYPE_USAGE	The table stores the allowable control item types for each project type.
Column Name	Descritpion
CI_TYPE_USAGE_ID	System-generated number that uniquely identifies the control item type usage
PROJECT_TYPE_ID	System-generated number that uniquely identifies the project type
CI_TYPE_ID	System-generated number that uniquely identifies the control item type
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Projects - PA_COMP_OT_EXP_TYPES	PA_COMP_OT_EXP_TYPES assigns labor cost multipliers to overtime expenditure types for each labor costing rule. The multipliers are applied as raw cost is calculated for transactions charged to the associated expenditure types.
Column Name	Descritpion
EXPENDITURE_TYPE	Overtime expenditure type to which premium rates are applied.
LABOR_COST_MULTIPLIER_NAME	Labor Cost Multiplier used to calculate premium overtime amounts
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
LABOR_COSTING_RULE	Implementation defined name that uniquely identifies the costing rule.

Projects - PA_CONTROL_ITEMS	PA_CONTROL_ITEMS stores user-defined control items in a project. Each item is of an item type as specified by the CI_TYPE_ID column. The items are categorized using the Classification, Reason and Priority attributes
Column Name	Descritpion
CI_ID	The system-generated number that uniquely identifies the control item, shown on the user-interface as System Number
REASON_CODE_ID	The category code identifier indicates the reason of the control item
RECORD_VERSION_NUMBER	Number used for record locking in self service applications
PROJECT_ID	The identifier of the project for which the control item is created
LAST_MODIFICATION_DATE	The date when the control item or its impacts were last modified
LAST_MODIFIED_BY_ID	The identifier of the person who last modified the control item
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CI_TYPE_ID	The identifier of the control item type to which the item belongs
OBJECT_TYPE	Code indicating the object type for which the control item is created
OBJECT_ID	The identifier of the object for which the control item is created. For example: object_type=PA_TASKS and object_id is project_element_id
CI_NUMBER	A number that uniquely identifies the control item of a given type within a project. It can be user-defined or system-generated, depending on an option set up on the control item type level
DATE_REQUIRED	The date on which the control item is required
DATE_CLOSED	The date on which the control item was closed
CLOSED_BY_ID	The identifier of the person who closed control item
DESCRIPTION	User-defined description of the control item
STATUS_OVERVIEW	The overview for the status of the control item
RESOLUTION	The resolution for the control item
RESOLUTION_CODE_ID	The category code identifier indicates the type of the resolution
SUMMARY	User-defined short summary of the control item
PRIORITY_CODE	Lookup code indicating the priority of the control item. This is the same set of lookup codes as used for task priority
EFFORT_LEVEL_CODE	The lookup code indicating the level of effort of the control item
OPEN_ACTION_NUM	The number of open actions on the control item
PRICE	The price of the control item
PRICE_CURRENCY_CODE	The currency code for the price
SOURCE_TYPE_CODE	Lookup code indicating the type of the source of the control item
SOURCE_COMMENT	A comment on the source of the control item
SOURCE_NUMBER	User-defined number to identify the source of the control item
SOURCE_DATE_RECEIVED	The date on which the source was received
SOURCE_ORGANIZATION	The name of the organization of the source of the control item
STATUS_CODE	The user status code for the control item
SOURCE_PERSON	The name of the person of who is the source of the control item
LAST_ACTION_NUMBER	The identifier of the last action for the control item
ATTRIBUTE_CATEGORY	Descriptive flexfield context field
ATTRIBUTE1	Descriptive flexfield context field
ATTRIBUTE2	Descriptive flexfield context field
ATTRIBUTE3	Descriptive flexfield context field
ATTRIBUTE4	Descriptive flexfield context field
ATTRIBUTE5	Descriptive flexfield context field
ATTRIBUTE6	Descriptive flexfield context field
ATTRIBUTE7	Descriptive flexfield context field
OWNER_ID	The identifier of the owner of the control item
ATTRIBUTE8	Descriptive flexfield context field
ATTRIBUTE9	Descriptive flexfield context field
ATTRIBUTE10	Descriptive flexfield context field
ATTRIBUTE11	Descriptive flexfield context field
ATTRIBUTE12	Descriptive flexfield context field
ATTRIBUTE13	Descriptive flexfield context field
ATTRIBUTE14	Descriptive flexfield context field
ATTRIBUTE15	Descriptive flexfield context field
ORIG_SYSTEM_CODE	The identifier of the external project management system from which the control item was imported.
ORIG_SYSTEM_REFERENCE	The identifier of the control item in the external project management system from which the control item was imported.
APPROVAL_TYPE_CODE	This column stores the Approval Type code required for the change document.
PCO_STATUS_CODE	This column stores the PCO report acceptance status code for change requests that require external approval.
HIGHLIGHTED_FLAG	Indicator that the control item is included in the project status report
LOCKED_FLAG	The value in this column indicates whether the change document is locked. The value Y indicates locked status.
PCO_SEQUENCE	This column stores the numbering sequence for Potential Change Order report.
VERSION_NUMBER	This column stores the version of the change document.
CURRENT_VERSION_FLAG	The value in this column distinguishes between a current and previous version of the change document. A value of Y indicates current version.
ORIGINAL_CI_ID	This column stores the ID of the original change document from which the change document is created.
SOURCE_CI_ID	This column stores the ID of the change document version from which the change document is created.
VERSION_COMMENTS	version comments of the change document
CHANGE_APPROVER	This column stores the name of the customer who can approve the change request.
PROGRESS_STATUS_CODE	The user stautus code for the progress of the control item
PROGRESS_AS_OF_DATE	The as of date of the progress status
CLASSIFICATION_CODE_ID	The category code identifier indicates the classification of the control item

Projects - PA_ASSET_INFO_GTEMP	A temporary table used to store summarized data. used during cost processing for capital projects
Column Name	Descritpion
PROJECT_ID	The system generated number that uniquely identifies the project.
RETIRED_COST	Interfaced RWIP Cost
TOTAL_CAP_COST	Total cost for capitalizable tasks
TOTAL_RET_COST	Total cost for retirement tasks
TASK_ID	The system generated number that uniquely identifies the task within a project.
TASK_NUMBER	User-defined number that uniquely identifies the task within a project.
TASK_NAME	User-defined name that uniquely identifies the task within a project.
PARENT_TASK_ID	The identifier of the parent task that owns this task
WBS_LEVEL	The level of the task in the Work breakdown structure
CAPITALIZABLE_COST	Open CIP cost
RETIRABLE_COST	Open RWIP cost
CAPITALIZED_COST	Interfaced CIP Cost

Projects - PA_ASSET_INFO_GTEMP1	A temporary table used to store summarized data used during cost processing for capital projects. This table should be an exact replica of the PA_ASSET_INFO_GTEMP table
Column Name	Descritpion
PROJECT_ID	The system generated number that uniquely identifies the project.
RETIRED_COST	Interfaced RWIP Cost
TOTAL_CAP_COST	Total cost for capitalizable tasks
TOTAL_RET_COST	Total cost for retirement tasks
TASK_ID	The system generated number that uniquely identifies the task within a project.
TASK_NUMBER	User-defined number that uniquely identifies the task within a project.
TASK_NAME	User-defined name that uniquely identifies the task within a project.
PARENT_TASK_ID	The identifier of the parent task that owns this task
WBS_LEVEL	The level of the task in the Work breakdown structure
CAPITALIZABLE_COST	Open CIP cost
RETIRABLE_COST	Open RWIP cost
CAPITALIZED_COST	Interfaced CIP Cost

Projects - PA_AUD_COST_DIST_LINES	PA_AUD_COST_DIST_LINES stores audit information for summarized burden expenditure items.
Column Name	Descritpion
LINE_NUM	The sequential number that identifies the cost distribution line
IND_COMPILED_SET_ID	The identifier of the compiled set used to calculate the burden cost.
BURDEN_SUM_SOURCE_RUN_ID	Identifies the group of cost distribution lines that were summarized to create burden cost expenditure items.
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
PROGRAM_ID	Standard Who Column
EXPENDITURE_ITEM_ID	The identifier of the expenditure item that is cost distributed by the distribution line.
PROGRAM_APPLICATION_ID	Standard Who Column
REQUEST_ID	Standard Who Column

Projects - PA_CAPITAL_EVENTS	Stores information about events used to group costs and assets for capitalization and events used to generate retirement cost adjustments. Based on the Event Processing Method defined at the project level, capital events are system generat
Column Name	Descritpion
CAPITAL_EVENT_ID	Capital event identifier.
CREATION_DATE	Standard Who column.
CREATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
REQUEST_ID	Standard Program Update column.
PROGRAM_APPLICATION_ID	Standard Program Update column.
PROGRAM_ID	Standard Program Update column.
PROGRAM_UPDATE_DATE	Standard Program Update column.
PROJECT_ID	The system generated number that uniquely identifies the project.
CAPITAL_EVENT_NUMBER	Number that identifies the event within the Project.
EVENT_TYPE	Event Classification. Available values are "C" = "Capital" and "R" = "Retirement".
EVENT_NAME	User defined event name.
ASSET_ALLOCATION_METHOD	Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level.
EVENT_PERIOD	General Ledger Period associated with the event.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Projects - PA_CINT_EXP_TYPE_EXCL_ALL	Stores expenditure type exclusions by interest rate code for each operating unit. Cost associated with each expenditure type is excluded from the capitalized interest calculation
Column Name	Descritpion
IND_COST_CODE	Interest Rate Code
EXPENDITURE_TYPE	Expenditure type to be excluded form the Interest Calculation
ORG_ID	Operating unit ID
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Projects - PA_CINT_RATE_INFO_ALL	Stores information used to determine how capitalized interest is calculated for each operating unit
Column Name	Descritpion
IND_COST_CODE	Interest Rate Code
CURR_PERIOD_CONVENTION	Determines how much of the current periods CIP amount is included in the capitalized interest calculation
INTEREST_CALCULATION_METHOD	Indicates whether simple or compound interest is used during capitalized interest calculation
PERIOD_RATE_CODE	Determine how interest amounts are prorated across General Ledger periods
ORG_ID	Operating unit ID
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
EXP_ORG_SOURCE	The source of the expenditure organization to be used on capitalized interest transactions
THRESHOLD_AMT_TYPE	The amount type used for defining thresholds
BUDGET_TYPE_CODE	Identifies the budget type on which threshold amounts are based
FIN_PLAN_TYPE_ID	Identifies the financial plan type on which threshold amounts are based
PROJ_AMT_THRESHOLD	Project amount threshold
TASK_AMT_THRESHOLD	Task amount threshold
PROJ_DURATION_THRESHOLD	Project duration threshold
TASK_DURATION_THRESHOLD	Task duration threshold

Projects - PA_CINT_RATE_MULTIPLIERS	Stores complied capitalized interest schedule revisions, denormalized by revision, organization and rate name. The multipliers in this table are used during the calculation and generation of Capitalized Interest transactions.
Column Name	Descritpion
IND_RATE_SCH_REVISION_ID	Rate Schedule Revision Identifier
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent program request ID
PROGRAM_APPLICATION_ID	Concurrent program Application ID
PROGRAM_ID	Concurrent program ID
PROGRAM_UPDATE_DATE	Concurrent program update date
ORGANIZATION_ID	Organization Identifier
IND_RATE_SCH_ID	Interest Rate Schedule Identifier
RATE_NAME	Interest Rate Name
MULTIPLIER	Complied Interest Rate Value
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Projects - PA_CINT_SOURCE_DETAILS	Stores the source detail expenditures used to create the associated Capitalized Interest transactions.
Column Name	Descritpion
ALLOC_TXN_ID	Allocation Transaction Identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PROJECT_ID	Project Identifier
FISCAL_YEAR	End date of the calculation p period
PERIOD_NUM	Fiscal year of the calculation period
RUN_PERIOD_END_DATE	Calculation period number
EXPENDITURE_ITEM_ID	Expenditure Item Identifier
LINE_NUM	Expenditure Distribution Line Number
PRIOR_AMOUNT	Prior basis amount used to create the interest transaction
CURRENT_AMOUNT	Current basis amount used to create the interest transaction.

Projects - PA_CI_FP_AMOUNTS	This table stores the materialized financial amount data for the control items.
Column Name	Descritpion
CI_ID	Unique identifier of the control item.
EST_PROJECT_RAW_COST	Estimated project raw cost.
TOTAL_PROJECT_RAW_COST	Total project raw cost.
EST_PROJECT_BURDENED_COST	Estimated project burdened cost.
TOTAL_PROJECT_BURDENED_COST	Total project burdened cost.
EST_PROJECT_REVENUE	Estimated project revenue.
TOTAL_PROJECT_REVENUE	Total project revenue.
EST_PROJECT_COST	Estimated project cost.
TOTAL_PROJECT_COST	Total project cost.
DERIVED_QUANTITY	Derived quantity.
DERIVED_COST	Derived cost.
PROJECT_ID	Unique identifier of the project.
DERIVED_REVENUE	Derived revenue.
EST_MARGIN	Estimated margin.
EST_MARGIN_PERCENTAGE	Estimated margin percentage.
PLANNED_MARGIN	Planned margin.
PLANNED_MARGIN_PERCENTAGE	Planned margin percentage.
DERIVED_MARGIN	Derived margin.
DERIVED_MARGIN_PERCENTAGE	Derived margin percentage.
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
EST_QUANTITY	Estimated quantity.
LABOR_QUANTITY	Labor quantity.

Projects - PA_COMMITMENT_TXNS_TMP	This is an internal table that is used to store temporary data required during update project summary amounts internal processing. This is a global temporary table.
Column Name	Descritpion
PROJECT_ID
PA_PERIOD
GL_PERIOD
CMT_LINE_NUMBER
CMT_CREATION_DATE
CMT_APPROVED_DATE
CMT_REQUESTOR_NAME
CMT_BUYER_NAME
CMT_APPROVED_FLAG
CMT_PROMISED_DATE
CMT_NEED_BY_DATE
TASK_ID
ORGANIZATION_ID
VENDOR_ID
VENDOR_NAME
EXPENDITURE_TYPE
EXPENDITURE_CATEGORY
REVENUE_CATEGORY
SYSTEM_LINKAGE_FUNCTION
UNIT_OF_MEASURE
UNIT_PRICE
CMT_IND_COMPILED_SET_ID
TRANSACTION_SOURCE
ACCT_RAW_COST
ACCT_BURDENED_COST
TOT_CMT_QUANTITY
QUANTITY_ORDERED
AMOUNT_ORDERED
ORIGINAL_QUANTITY_ORDERED
ORIGINAL_AMOUNT_ORDERED
QUANTITY_CANCELLED
AMOUNT_CANCELLED
QUANTITY_DELIVERED
LINE_TYPE
QUANTITY_INVOICED
AMOUNT_INVOICED
QUANTITY_OUTSTANDING_DELIVERY
AMOUNT_OUTSTANDING_DELIVERY
QUANTITY_OUTSTANDING_INVOICE
AMOUNT_OUTSTANDING_INVOICE
QUANTITY_OVERBILLED
AMOUNT_OVERBILLED
ORIGINAL_TXN_REFERENCE1
ORIGINAL_TXN_REFERENCE2
CMT_NUMBER
ORIGINAL_TXN_REFERENCE3
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CMT_DISTRIBUTION_ID
DENOM_CURRENCY_CODE
DENOM_RAW_COST
DENOM_BURDENED_COST
ACCT_CURRENCY_CODE
ACCT_RATE_DATE
ACCT_RATE_TYPE
ACCT_EXCHANGE_RATE
RECEIPT_CURRENCY_CODE
RECEIPT_CURRENCY_AMOUNT
RECEIPT_EXCHANGE_RATE
CMT_HEADER_ID
INVENTORY_ITEM_ID
INVENTORY_ITEM_NAME
UOM_CODE
WIP_RESOURCE_ID
WIP_RESOURCE_NAME
RESOURCE_CLASS
DESCRIPTION
EXPENDITURE_ITEM_DATE

Projects - PA_BUDGET_LINES_M_UPG_DTRANGE	INTERNAL
Column Name	Descritpion
RESOURCE_ASSIGNMENT_ID	The identifier of the resource assignment of the budget line.
QUANTITY	The quantity of the budget line.
RAW_COST	The raw cost of the budget line.
BURDENED_COST	The burdened cost of the budget line.
REVENUE	The revenue of the budget line.
CHANGE_REASON_CODE	The reason to create the budget line.
DESCRIPTION	Descriptive flexfield context field.
ATTRIBUTE_CATEGORY	Descriptive flexfield segment.
ATTRIBUTE1	Descriptive flexfield segment.
ATTRIBUTE2	Descriptive flexfield segment.
ATTRIBUTE3	Descriptive flexfield segment.
START_DATE	The start date of the budget line.
ATTRIBUTE4	Descriptive flexfield segment.
ATTRIBUTE5	Descriptive flexfield segment.
ATTRIBUTE6	Descriptive flexfield segment.
ATTRIBUTE7	Descriptive flexfield segment.
ATTRIBUTE8	Descriptive flexfield segment.
ATTRIBUTE9	Descriptive flexfield segment.
ATTRIBUTE10	Descriptive flexfield segment.
ATTRIBUTE11	Descriptive flexfield segment.
ATTRIBUTE12	Descriptive flexfield segment.
ATTRIBUTE13	Descriptive flexfield segment.
LAST_UPDATE_DATE	Standard who column.
ATTRIBUTE14	Descriptive flexfield segment.
ATTRIBUTE15	Descriptive flexfield segment.
RAW_COST_SOURCE	Currently not used.
BURDENED_COST_SOURCE	Currently not used.
QUANTITY_SOURCE	Currently not used.
REVENUE_SOURCE	Currently not used.
PM_PRODUCT_CODE	The identifier of the external project management system from which the budget was imported.
PM_BUDGET_LINE_REFERENCE	The identifier of the budget in the external project management system from which the budget was imported.
COST_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of cost amounts.
REVENUE_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of revenue amounts.
LAST_UPDATED_BY	Standard who column.
BURDEN_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an error is encountered during calculation of burdened cost amounts.
OTHER_REJECTION_CODE	This column applies to generation of project forecasts. It stores the message code that is applicable whenever an unexpected error is encountered.
CODE_COMBINATION_ID	Accounting code identifier for the budget line.
CCID_GEN_STATUS_CODE	This indicates the following for accounting code generation : (P) Pending, (G) Generated, (E) Error in Generating Account.
CCID_GEN_REJ_MESSAGE	Message for account generation failure reason.
REQUEST_ID	The concurrent request id of the budget line being processed.
BORROWED_REVENUE	The borrowed revenue of budget line.
TP_REVENUE_IN	The transfer-price revenue in of budget line.
TP_REVENUE_OUT	The transfer-price revenue out of budget line.
REVENUE_ADJ	The revenue adjustment of budget line.
CREATION_DATE	Standard who column.
LENT_RESOURCE_COST	The lent resource cost of budget line.
TP_COST_IN	The transfer-price cost in of budget line.
TP_COST_OUT	The transfer-price cost out of budget line.
COST_ADJ	The cost adjustment of budget line.
UNASSIGNED_TIME_COST	The unassigned time cost of budget line.
UTILIZATION_PERCENT	The utilization percent of budget line.
UTILIZATION_HOURS	The utilization hours of budget line.
UTILIZATION_ADJ	The utilization percent adjustment of budget line.
CAPACITY	The capacity of budget line.
HEAD_COUNT	The head count of budget line.
CREATED_BY	Standard who column.
HEAD_COUNT_ADJ	The head count adjustment of budget line.
PROJFUNC_CURRENCY_CODE	The project functional currency code.
PROJFUNC_COST_RATE_TYPE	The project functional cost rate type .
PROJFUNC_COST_EXCHANGE_RATE	The project functional cost exchange rate.
PROJFUNC_COST_RATE_DATE_TYPE	The project functional cost rate date type.
PROJFUNC_COST_RATE_DATE	The cost rate date for project functional currency.
PROJFUNC_REV_RATE_TYPE	The project functional revenue rate type.
PROJFUNC_REV_EXCHANGE_RATE	The project functional revenue exchange rate.
PROJFUNC_REV_RATE_DATE_TYPE	The project functional revenue rate date type.
PROJFUNC_REV_RATE_DATE	The revenue rate date for project functional currency.
LAST_UPDATE_LOGIN	Standard who column.
PROJECT_CURRENCY_CODE	The project currency code.
PROJECT_COST_RATE_TYPE	The project cost rate type.
PROJECT_COST_EXCHANGE_RATE	The project cost exchange rate.
PROJECT_COST_RATE_DATE_TYPE	The project cost rate date type.
PROJECT_COST_RATE_DATE	The cost rate date for project currency.
PROJECT_RAW_COST	The project raw cost.
PROJECT_BURDENED_COST	The project burdened cost.
PROJECT_REV_RATE_TYPE	The project revenue rate type.
PROJECT_REV_EXCHANGE_RATE	The project revenue exchange rate.
PROJECT_REV_RATE_DATE_TYPE	The project revenue rate date type .
END_DATE	The end date of the budget line.
PROJECT_REV_RATE_DATE	The revenue rate date for project currency.
PROJECT_REVENUE	The project revenue.
TXN_CURRENCY_CODE	The transaction currency code of the amount.
TXN_RAW_COST	The raw cost in transaction currency.
TXN_BURDENED_COST	The burdened cost in transaction currency.
TXN_REVENUE	The revenue in transaction currency.
BUCKETING_PERIOD_CODE	Determines whether bucket is for preceding or succeeding periods.
BUDGET_LINE_ID	Unique identifier of budget line.
BUDGET_VERSION_ID	Unique identifier of budget version.
BUDGET_VERSION_ID_RUP	Unique identifier of budget version upgraded in the Optional upgrade
RESOURCE_ASSIGNMENT_ID_RUP	The identifier of the resource assignment of the budget line that is rolled up using optional upgrade
PERIOD_NAME	The period of the budget line.

Projects - PA_COMP_RULE_OT_DEFAULTS_ALL	This table stores the overtime default project and task details for a Labor costing rule.
Column Name	Descritpion
COMPENSATION_RULE_SET	IMPLEMENTATION-DEFINED NAME THAT UNIQUELY IDENTIFIES THE COMPENSATION RULE
PROJECT_ID	THE IDENTIFIER OF THE OVERTIME PROJECT THAT DEFAULTS UPON MANUAL ENTRY OF OVERTIME LABOR ITEMS FOR EMPLOYEES ASSIGNED TO THE COMPENSATION RULE
TASK_ID	THE IDENTIFIER OF THE TASK THAT DEFAULTS UPON MANUAL ENTRY OF OVERTIME LABOR ITEMS FOR EMPLOYEES ASSIGNED TO THE COMPENSATION RULE
ORG_ID	OPERATING UNIT IDENTIFIER FOR MULTI-ORGANIZATION INSTALLATIONS
LAST_UPDATED_BY	STANDARD WHO COLUMN
LAST_UPDATE_DATE	STANDARD WHO COLUMN
LAST_UPDATE_LOGIN	STANDARD WHO COLUMN
CREATED_BY	STANDARD WHO COLUMN
CREATION_DATE	STANDARD WHO COLUMN

Projects - PA_COSTING_AUDIT	This is an internal audit table used by Oracle Projects
Column Name	Descritpion
MODULE_CODE	Module from which audit record is inserted.
REFERENCE3	Reference column.
REFERENCE4	Reference column.
REFERENCE5	Reference column.
REFERENCE6	Reference column.
REFERENCE7	Reference column.
REFERENCE8	Reference column.
REFERENCE9	Reference column.
REFERENCE10	Reference column.
CREATION_DATE	Standard Who column .
CREATED_BY	Standard Who column .
ACTIVITY_CODE	Stores the activity of the audit record.
LAST_UPDATE_DATE	Standard Who column .
LAST_UPDATED_BY	Standard Who column .
LAST_UPDATE_LOGIN	Standard Who column .
REQUEST_ID	Standard Who column .
PROGRAM_APPLICATION_ID	Standard Who column .
PROGRAM_ID	Standard Who column .
PROGRAM_UPDATE_DATE	Standard Who column .
ACTIVITY_DATE	The date when the activity occured.
DESCRIPTION	Description of the activity.
PK01	Primary key column.
PK02	Primary key column.
PK03	Primary key column.
REFERENCE1	Reference column.
REFERENCE2	Reference column.

Projects - PAXINGEN_PA_PROJ_SUM_TEMP	The PAAPIMPR_RCV_SUB_SUM_TEMP temporary table is used by the report of Interface Supplier Costs process.
Column Name	Descritpion
ORGANIZATION_ID	This is the Organization id of the project.
DESCRIPTION	This is the description of the project.
BUDGET_REVENUE_AMOUNT	This is the budget revenue amount for the project.
TOTAL_REVENUE_AMOUNT	This is the total revenue amount for the project.
WRITE_OFF_REVENUE_AMOUNT	This is the write_off revenue amount for the project.
WRITE_ON_REVENUE_AMOUNT	This is the write_on revenue amount for the project.
INVOICED_AMOUNT	This is the invoiced amount for the project.
TOTAL_RETENTION_AMOUNT	This is the total retention amount for the project.
RETENTION_BILLED_AMOUNT	This is the retention billed amount amount for the project.
TOTAL_INVOICE_AMOUNT	This is the total invoice amount for the project.
PROJFUNC_INVOICE_AMOUNT	This is the invoice amount for the project in functional currency.
ORGANIZATION_NAME	This is the Organization name of the project.
PROJFUNC_TOT_RETN_AMOUNT	This is the total retention amount for the project in functional currency.
PROJFUNC_RETN_BILLED_AMOUNT	This is the retention billed amount for the project in functional currency.
PROJFUNC_TOT_INV_AMOUNT	This is the total invoice amount for the project in functional currency.
ON_HOLD_AMOUNT	This is the on hold amount for the project.
ON_HOLD_QUANTITY	This is the on_hold_quantity for the project.
INVOICE_LESS_WRITEOFF	This is the invoice less write off amount for the project.
INVOICE_WRITEOFF	This is the invoice writeoff amount for the project.
MEMBER_PERSON_ID	This is the person id of the member of the project.
MEMBER_NAME	This is the member_name of the project.
PROJECT_ROLE_TYPE	This is the project_role_type of the member of the project.
PROJECT_ROLE	This is the project_role of the member of the project
PROJECT_ID	This is the project_id of the project.
PROJECT_NUMBER	This is the Organization id.
PROJECT_NAME	This is the project_number of the project.

Projects - PA_CUST_STATUS_TMP
Column Name	Descritpion
CUSTOMER_ID
INV_CURRENCY_CODE
INV_RATE_TYPE
INV_RATE_DATE
INV_EXCHANGE_RATE
STATUS
CREDIT_FLAG

Projects - PA_DEDUCTIONS_ALL	This table contains summary information about the deduction requests raised for suppliers.
Column Name	Descritpion
DEDUCTION_REQ_ID	This is a system generated number that uniquely identifies a deduction request.
DEDUCTION_REQ_NUM	This is the deduction request number.
DEBIT_MEMO_NUM	This is the debit memo number associated with the deduction request.
CURRENCY_CODE	This is the debit memo transaction currency code.
CONVERSION_RATETYPE	This is the currency conversion rate type used to convert the project functional currency to transaction currency.
CONVERSION_RATEDATE	This is the date on which the defined currency conversion rate is applicable.
CONVERSION_RATE	This is the currency conversion rate used to convert projects functional currency amount to the transaction currency amount.
TOTAL_AMOUNT	This is the total deduction request amount expressed in the transaction currency
TOTAL_PFC_AMOUNT	This is the total deduction request amount expressed in the projects functional currency.
DEDUCTION_REQ_DATE	This is the date on which the deduction request is created.
DEBIT_MEMO_DATE	This is the date on which the debit memo is created.
PROJECT_ID	This is the ID of the project for which the deduction request is created.
DESCRIPTION	This is a description of the debit memo
STATUS	This is the status of the deduction request.
ORG_ID	This is the organization ID.
DOCUMENT_TYPE	This is the type of document associated with the deduction request. The document type can be M for miscellaneous deductions or C for deductions created with a change order.
CREATION_DATE	This is the date on which the deduction request was created.
CREATED_BY	This is the ID of the user who created the deductions request.
LAST_UPDATION_DATE	This is the date on which the deduction request was last updated.
LAST_UPDATED_BY	This is the ID of the user who last updated the deductions request.
VENDOR_ID	This is the ID of the supplier against whom the debit memo needs to be raised.
VENDOR_SITE_ID	This is the supplier site ID.
CHANGE_DOC_NUM	This is the denormalized change document number. A change document can be a change order or change request.
CHANGE_DOC_TYPE	This is the change document type.
CI_ID	This is the ID of the control item associated with the change document that is used in the deduction request.
PO_HEADER_ID	This is the ID of the purchase order associated with the deduction request.
PO_NUMBER	This is the denormalized purchase order number and is taken from column "Segment1" of PO_HEADER_ALL table.

Projects - PA_DEDUCTION_TRANSACTIONS_ALL	This table contains detailed information about the deduction requests raised for suppliers.
Column Name	Descritpion
DEDUCTION_REQ_ID	This is the ID of the deduction request to which the deduction transaction belongs.
EXPENDITURE_ITEM_DATE	This is the date on which the work was done.
GL_DATE	This is the accounting date
PROJFUNC_CURRENCY_CODE	This is the project functional currency code.
ORIG_PROJFUNC_AMOUNT	This is the amount expressed in the project functional currency.
OVERRIDE_PROJFUNC_AMOUNT	This is the modified amount expressed in the projects functional currency.
CONVERSION_RATETYPE	This is the currency conversion rate type used to convert the projects functional currency to the transaction currency.
CONVERSION_RATEDATE	This indicates the date on which the defined currency conversion rate is applicable.
CONVERSION_RATE	This is the currency conversion rate used to convert projects functional currency amount to the transaction currency amout.
AMOUNT	This is the deduction line amount expressed in the transaction currency
DESCRIPTION	This is the description of the deduction line.
DEDUCTION_REQ_TRAN_ID	This is a system generated number that uniquely identifies a deduction transaction.
CREATION_DATE	This is the date on which the deduction request was created.
CREATED_BY	This is the ID of the user who created the deductions request.
LAST_UPDATION_DATE	This is the date on which the deduction request was last updated.
LAST_UPDATED_BY	This is the ID of the user who last updated the deductions request.
PROJECT_ID	This is the ID of the project to which the deduction transaction is charged.
TASK_ID	This is the ID of the task to which the deduction transaction is charged.
EXPENDITURE_TYPE	This is used to classify the type of work performed.
EXPENDITURE_ORG_ID	This is the ID of the expenditure organization to which the cost is charged.
QUANTITY	This is the quantity of work done by the supplier.
OVERRIDE_QUANTITY	This is the work quantity modified by user. In case of an expenditure item mapped to a deduction line, users can modify the existing quantity. The modified quantity is stored as override quantity.
EXPENDITURE_ITEM_ID	This is the ID of the expenditure item mapped to a deduction line.

Projects - PA_ASGMT_PLAN_CHANGE_T
Column Name	Descritpion
PROJECT_ID
STRCUT_VER_ID
PUB_STRCUT_VER_ID