shilpisingh-oracle/SQL-Optimization

1PJC\_ACCT\_SWEEPER\_LOGS2 3Foreign key to PJC\_EXP\_ITEMS\_ALL.EXPENDITURE\_ITEM\_ID4 5Details6 7- Schema: FUSION8- Object owner: PJC9- Object type: TABLE10- Tablespace: FUSION\_TS\_TX\_DATA11 12Primary Key13 14|**Name**|**Columns**|15| :- | :- |16|PJC\_ACCT\_SWEEPER\_LOGS\_PK|EXPENDITURE\_ITEM\_ID, CDL\_LINE\_NUM, PRVDR\_GL\_DATE, PROJECT\_RAW\_COST|17 18Columns19 20|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|21| :- | :- | :- | :- | :- | :- |22|EXPENDITURE\_ITEM\_ID|NUMBER|||Yes|EXPENDITURE\_ITEM\_ID \*\*\*\*\*|23|CDL\_LINE\_NUM|NUMBER|||Yes|CDL\_LINE\_NUM \*\*\*\*\*|24|DENOM\_CURRENCY\_CODE|VARCHAR2|15|||DENOM\_CURRENCY\_CODE \*\*\*\*\*|25|PJS\_SUMMARY\_ID|NUMBER||||PJS\_SUMMARY\_ID \*\*\*\*\*|26|TXN\_ACCUM\_HEADER\_ID|NUMBER||||TXN\_ACCUM\_HEADER\_ID \*\*\*\*\*|27|PROJECT\_ID|NUMBER||||PROJECT\_ID \*\*\*\*\*|28|TASK\_ID|NUMBER||||TASK\_ID \*\*\*\*\*|29|PRVDR\_GL\_DATE|DATE|||Yes|PRVDR\_GL\_DATE \*\*\*\*\*|30|RECVR\_GL\_DATE|DATE||||RECVR\_GL\_DATE \*\*\*\*\*|31|RECVR\_GL\_PERIOD\_NAME|VARCHAR2|15|||RECVR\_GL\_PERIOD\_NAME \*\*\*\*\*|32|PRVDR\_PA\_DATE|DATE||||PRVDR\_PA\_DATE \*\*\*\*\*|33|RECVR\_PA\_DATE|DATE||||RECVR\_PA\_DATE \*\*\*\*\*|34|RECVR\_PA\_PERIOD\_NAME|VARCHAR2|15|||RECVR\_PA\_PERIOD\_NAME \*\*\*\*\*|35|BILLABLE\_FLAG|VARCHAR2|1|||BILLABLE\_FLAG \*\*\*\*\*|36|CAPITALIZABLE\_FLAG|VARCHAR2|1|||CAPITALIZABLE\_FLAG \*\*\*\*\*|37|DENOM\_RAW\_COST|NUMBER||||DENOM\_RAW\_COST \*\*\*\*\*|38|DENOM\_BURDENED\_COST|NUMBER||||DENOM\_BURDENED\_COST \*\*\*\*\*|39|PROJECT\_RAW\_COST|NUMBER|||Yes|PROJECT\_RAW\_COST \*\*\*\*\*|40|PROJECT\_BURDENED\_COST|NUMBER||||PROJECT\_BURDENED\_COST \*\*\*\*\*|41|PROJFUNC\_RAW\_COST|NUMBER||||PROJFUNC\_RAW\_COST \*\*\*\*\*|42|PROJFUNC\_BURDENED\_COST|NUMBER||||PROJFUNC\_BURDENED\_COST \*\*\*\*\*|43|QUANTITY|NUMBER||||QUANTITY \*\*\*\*\*|44|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|45|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|46|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|47|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|48|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|49|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|50|BUDGET\_PERIOD\_ID|NUMBER||18||Identifier of Budget Period for which the funding is made.|51 52Foreign Keys53 54|**Table**|**Foreign Table**|**Foreign Key Column**|55| :- | :- | :- |56|PJC\_ACCT\_SWEEPER\_LOGS|pjc\_exp\_items\_all|EXPENDITURE\_ITEM\_ID|57 58Indexes59 60|**Index**|**Uniqueness**|**Tablespace**|**Columns**|61| :- | :- | :- | :- |62|PJC\_ACCT\_SWEEPER\_LOGS\_N2|Non Unique|Default|PJS\_SUMMARY\_ID|63|PJC\_ACCT\_SWEEPER\_LOGS\_N3|Non Unique|Default|PROJECT\_ID|64|PJC\_ACCT\_SWEEPER\_LOGS\_U1|Unique|Default|EXPENDITURE\_ITEM\_ID, CDL\_LINE\_NUM, PRVDR\_GL\_DATE, PROJECT\_RAW\_COST|65 66PJC\_ALLOC\_EXCEPTIONS67 68PA\_ALLOC\_EXCEPTIONS stores all exceptions in an allocation run.69 70Details71 72- Schema: FUSION73- Object owner: PJC74- Object type: TABLE75- Tablespace: APPS\_TS\_TX\_DATA76 77Primary Key78 79|**Name**|**Columns**|80| :- | :- |81|PJC\_ALLOC\_EXCEPTIONS\_PK|EXCEPTION\_ID|82 83Columns84 85|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|86| :- | :- | :- | :- | :- | :- |87|EXCEPTION\_ID|NUMBER||18|Yes|New column added for prmary key \*\*\*\*\*|88|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|89|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|90|LEVEL\_CODE|VARCHAR2|2||Yes|It can be R(rule), S(source), T (target), B (basis) or O(offset)|91|EXCEPTION\_TYPE|VARCHAR2|1||Yes|Exception type. It can be W(warning) or E(error)|92|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|93|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|94|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|95|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|96|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|97|PROJECT\_ID|NUMBER||||Project ID|98|TASK\_ID|NUMBER||18||Task ID|99|EXCEPTION\_CODE|VARCHAR2|30|||Exception code to indicate exceptions|100|RUN\_TARGET\_ID|NUMBER||18||Primary key run\_target\_id from table pjc\_alloc\_run\_targets. Supporting the target level error message.|101|EXPENDITURE\_ITEM\_ID|NUMBER||18||Expenditure item ID.|102|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|103|TOKEN\_NAME1|VARCHAR2|30|||Used for error handling|104|TOKEN\_NAME2|VARCHAR2|30|||Used for error handling|105|TOKEN\_NAME3|VARCHAR2|30|||Used for error handling|106|TOKEN\_VALUE1|VARCHAR2|30|||Used for error handling|107|TOKEN\_VALUE2|VARCHAR2|30|||Used for error handling|108|TOKEN\_VALUE3|VARCHAR2|30|||Used for error handling|109 110Foreign Keys111 112|**Table**|**Foreign Table**|**Foreign Key Column**|113| :- | :- | :- |114|PJC\_ALLOC\_EXCEPTIONS|pjc\_alloc\_runs\_all|RUN\_ID|115 116Indexes117 118|**Index**|**Uniqueness**|**Tablespace**|**Columns**|119| :- | :- | :- | :- |120|PJC\_ALLOC\_EXCEPTIONS\_N1|Non Unique|Default|RUN\_ID, LEVEL\_CODE, EXCEPTION\_TYPE|121|PJC\_ALLOC\_EXCEPTIONS\_U1|Unique|Default|EXCEPTION\_ID|122 123PJC\_ALLOC\_GL\_LINES124 125PA\_ALLOC\_GL\_LINES stores allocation source lines that are related to GL accounts.126 127Details128 129- Schema: FUSION130- Object owner: PJC131- Object type: TABLE132- Tablespace: APPS\_TS\_TX\_DATA133 134Primary Key135 136|**Name**|**Columns**|137| :- | :- |138|PJC\_ALLOC\_GL\_LINES\_PK|RULE\_ID, LINE\_NUM|139 140Columns141 142|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|143| :- | :- | :- | :- | :- | :- |144|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|145|LINE\_NUM|NUMBER|||Yes|Line Number of the source line|146|SOURCE\_CCID|NUMBER||18|Yes|Code combination id for GL account|147|SUBTRACT\_FLAG|VARCHAR2|1||Yes|The flag indicates whether the GL account balance is subtracted. Y means subtracted|148|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|149|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|150|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|151|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|152|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|153|SOURCE\_PERCENT|NUMBER||||Percentage of account balance to be considered|154|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|155 156Foreign Keys157 158|**Table**|**Foreign Table**|**Foreign Key Column**|159| :- | :- | :- |160|PJC\_ALLOC\_GL\_LINES|gl\_code\_combinations|SOURCE\_CCID|161|PJC\_ALLOC\_GL\_LINES|pjc\_alloc\_rules\_all|RULE\_ID|162|pjc\_alloc\_run\_gl\_det|pjc\_alloc\_gl\_lines|RULE\_ID, LINE\_NUM|163 164Indexes165 166|**Index**|**Uniqueness**|**Tablespace**|**Columns**|167| :- | :- | :- | :- |168|PJC\_ALLOC\_GL\_LINES\_N1|Non Unique|Default|RULE\_ID, SUBTRACT\_FLAG|169|PJC\_ALLOC\_GL\_LINES\_U1|Unique|Default|RULE\_ID, LINE\_NUM|170 171PJC\_ALLOC\_MISSING\_COSTS172 173PA\_ALLOC\_MISSING\_COSTS stores missing costs information for an allocation run. This is applicable only for incremental allocation runs.174 175Details176 177- Schema: FUSION178- Object owner: PJC179- Object type: TABLE180- Tablespace: APPS\_TS\_TX\_DATA181 182Primary Key183 184|**Name**|**Columns**|185| :- | :- |186|PJC\_ALLOC\_MISSING\_COSTS\_PK|MISSING\_COST\_ID|187 188Columns189 190|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|191| :- | :- | :- | :- | :- | :- |192|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|193|MISSING\_COST\_ID|NUMBER||18|Yes|New column added for primary key \*\*\*\*\*|194|TYPE\_CODE|VARCHAR2|1||Yes|Missing costs type. It can be S(Source),T(Target) or O(Offset)|195|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|196|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|197|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|198|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|199|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|200|PROJECT\_ID|NUMBER||18|Yes|Project identification number|201|TASK\_ID|NUMBER||18|Yes|Task identification number|202|AMOUNT|NUMBER||||Missing amount from project/task|203|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|204 205Foreign Keys206 207|**Table**|**Foreign Table**|**Foreign Key Column**|208| :- | :- | :- |209|PJC\_ALLOC\_MISSING\_COSTS|pjc\_alloc\_runs\_all|RUN\_ID|210|PJC\_ALLOC\_MISSING\_COSTS|pjf\_projects\_all\_b|PROJECT\_ID|211|PJC\_ALLOC\_MISSING\_COSTS|pjf\_proj\_elements\_b|TASK\_ID|212 213Indexes214 215|**Index**|**Uniqueness**|**Tablespace**|**Columns**|216| :- | :- | :- | :- |217|PJC\_ALLOC\_MISSING\_COSTS\_N1|Non Unique|Default|RUN\_ID, TYPE\_CODE|218|PJC\_ALLOC\_MISSING\_COSTS\_U1|Unique|Default|MISSING\_COST\_ID|219 220PJC\_ALLOC\_RESOURCES221 222PA\_ALLOC\_RESOURCES stores resources and percentages for each allocation rule. This table stores both the basis resources and and source resources defined for an allocation rule.223 224Details225 226- Schema: FUSION227- Object owner: PJC228- Object type: TABLE229- Tablespace: APPS\_TS\_TX\_DATA230 231Primary Key232 233|**Name**|**Columns**|234| :- | :- |235|PJC\_ALLOC\_RESOURCES\_PK|RULE\_ID, MEMBER\_TYPE, RBS\_ELEMENT\_ID|236 237Columns238 239|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|240| :- | :- | :- | :- | :- | :- |241|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|242|MEMBER\_TYPE|VARCHAR2|1||Yes|Resource list member type. It can be S(source) or B(basis)|243|RBS\_ELEMENT\_ID|NUMBER||18|Yes|RBS Element Id \*\*\*\*\*|244|EXCLUDE\_FLAG|VARCHAR2|1||Yes|The flag indicates whether to exclude returned projects|245|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|246|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|247|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|248|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|249|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|250|RESOURCE\_PERCENTAGE|NUMBER||||Percentage of the resource amount to be used for allocation|251|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|252 253Foreign Keys254 255|**Table**|**Foreign Table**|**Foreign Key Column**|256| :- | :- | :- |257|PJC\_ALLOC\_RESOURCES|pjc\_alloc\_rules\_all|RULE\_ID|258 259Indexes260 261|**Index**|**Uniqueness**|**Tablespace**|**Columns**|262| :- | :- | :- | :- |263|PJC\_ALLOC\_RESOURCES\_N1|Non Unique|Default|RULE\_ID, MEMBER\_TYPE, EXCLUDE\_FLAG|264|PJC\_ALLOC\_RESOURCES\_U1|Unique|Default|RULE\_ID, MEMBER\_TYPE, RBS\_ELEMENT\_ID|265 266PJC\_ALLOC\_RULES\_ALL267 268PA\_ALLOC\_RULES\_ALL stores the information related to an allocation rule.269 270Details271 272- Schema: FUSION273- Object owner: PJC274- Object type: TABLE275- Tablespace: APPS\_TS\_TX\_DATA276 277Primary Key278 279|**Name**|**Columns**|280| :- | :- |281|PJC\_ALLOC\_RULES\_ALL\_PK|RULE\_ID|282 283Columns284 285|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|**Flexfield-mapping**|286| :- | :- | :- | :- | :- | :- | :- |287|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number||288|RULE\_NAME|VARCHAR2|60||Yes|Allocation rule name||289|ALLOCATION\_METHOD|VARCHAR2|1||Yes|Allocation method It can be F (full allocation) or I (incremental allocation)||290|TARGET\_EXP\_TYPE\_CLASS|VARCHAR2|30|||Expenditure type class of allocation transactions||291|TARGET\_EXP\_ORG\_ID|NUMBER||18||Expenditure organization of allocation transactions||292|TARGET\_EXP\_TYPE\_ID|NUMBER||18||Expenditure type of allocation transactions \*\*\*\*\*||293|TARGET\_COST\_TYPE|VARCHAR2|1||Yes|Cost type of allocation transactions It can be R(raw) or B (burdened)||294|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.||295|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.||296|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.||297|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.||298|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.||299|DESCRIPTION|VARCHAR2|240|||Allocation rule description||300|POOL\_PERCENT|NUMBER||||Allocation percentage specified at rule leveL||301|PERIOD\_TYPE|VARCHAR2|2|||Period type of GL (General Ledger) or PA (Oracle Projects)||302|SOURCE\_AMOUNT\_TYPE|VARCHAR2|4|||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||303|SOURCE\_BALANCE\_CATEGORY|VARCHAR2|1|||Source balance category A (Actuals) is only supported||304|SOURCE\_BALANCE\_TYPE|VARCHAR2|30|||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||305|ALLOC\_RBS\_HEADER\_ID|NUMBER||18||Alloc RBS header Id \*\*\*\*\*||306|AUTO\_RELEASE\_FLAG|VARCHAR2|1|||The flag indicates whether to create expenditure items automatically Y means release automatically||307|DUP\_TARGETS\_FLAG|VARCHAR2|1|||The flag indicates whether to allow duplicate target projects and tasksY means to allow duplicate target projects and tasks||308|OFFSET\_EXP\_TYPE\_CLASS|VARCHAR2|30|||Expenditure type class of offset transactions||309|OFFSET\_EXP\_ORG\_ID|NUMBER||18||Expenditure organization id of offset transactions||310|OFFSET\_EXP\_TYPE\_ID|NUMBER||18||Expenditure type of allocation transactions \*\*\*\*\*||311|OFFSET\_COST\_TYPE|VARCHAR2|1|||Cost type of offset transactions It can be B (burdened) or R (raw)||312|OFFSET\_METHOD|VARCHAR2|1|||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)||313|OFFSET\_PROJECT\_ID|NUMBER||18||Offset project id||314|OFFSET\_TASK\_ID|NUMBER||18||Offset task id||315|BASIS\_METHOD|VARCHAR2|2|||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)||316|BASIS\_RELATIVE\_PERIOD|NUMBER||||Relative basis period||317|BASIS\_AMOUNT\_TYPE|VARCHAR2|4|||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||318|BASIS\_BALANCE\_CATEGORY|VARCHAR2|1|||Basis balance category It can be A (actuals) or B (budgets)||319|BASIS\_BALANCE\_TYPE|VARCHAR2|30|||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||320|BASIS\_RBS\_HEADER\_ID|NUMBER||18||Basis RBS Header Id \*\*\*\*\*||321|SOURCE\_EXTN\_FLAG|VARCHAR2|1|||The flag indicates whether source extension exists Y means exist||322|TARGET\_EXTN\_FLAG|VARCHAR2|1|||The flag indicates whether target client extension exists Y means exist||323|FIXED\_AMOUNT|NUMBER||||Fixed source amount||324|START\_DATE\_ACTIVE|DATE||||The date when the rule becomes effective||325|END\_DATE\_ACTIVE|DATE||||The date when the rule becomes ineffective||326|ORG\_ID|NUMBER||18|Yes|Indicates the identifier of the business unit associated to the row.||327|TARGET\_LINE\_COUNT|NUMBER||18||Total target line count.||328|ATTRIBUTE\_CATEGORY|VARCHAR2|30|||Descriptive Flexfield: structure definition of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|329|ATTRIBUTE1|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|330|ATTRIBUTE2|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|331|ATTRIBUTE3|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|332|ATTRIBUTE4|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|333|ATTRIBUTE5|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|334|ATTRIBUTE6|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|335|ATTRIBUTE7|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|336|ATTRIBUTE8|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|337|ATTRIBUTE9|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|338|ATTRIBUTE10|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|339|ATTRIBUTE11|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|340|ATTRIBUTE12|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|341|ATTRIBUTE13|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|342|ATTRIBUTE14|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|343|ATTRIBUTE15|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|Project Allocation Rule (PJC\_ALLOC\_RULES\_DESC\_FLEX)|344|LIMIT\_TARGET\_PROJECTS\_CODE|VARCHAR2|1||Yes|Business organization level code that limits the selection of target projects||345|BASIS\_FIN\_PLAN\_TYPE\_ID|NUMBER||18||Fin plan type populated when allocation basis is Fin Plan||346|ALLOC\_RBS\_VERSION|NUMBER||||RBS structure version for allocation source resources.||347|BASIS\_RBS\_VERSION|NUMBER||||RBS structure version for allocation basis resources.||348|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.||349|RULE\_HDR\_ID|NUMBER||18||Primary key from parent table PJC\_RULES\_HDR||350|TYPE|VARCHAR2|30|||Type of labor schedule.||351|LD\_VERSION\_NAME|VARCHAR2|300|||Labor Schedule Version Name.||352|LD\_VERSION\_STATUS|VARCHAR2|30|||Status of the labor schedule version.||353|PERSON\_ID|NUMBER||18||Person ID related to the person record for this labor schedule.||354|ASSIGNMENT\_ID|NUMBER||18||Assignment ID related to the assignment record for this labor schedule.||355|LD\_VERSION\_COMMENTS|VARCHAR2|4000|||User defined comments for the version.||356|ALLOCATION\_GROUP\_NAME|VARCHAR2|60|||Attribute used for grouping allocation rules. Allocation group can only group allocations within a business unit with the same calendar type.||357|ELEMENT\_TYPE\_ID|NUMBER||18||Pay element type ID.||358|TIMECARD\_DIST\_FLAG|VARCHAR2|1|||Indicates that this is a time card based distribution rule.||359|PAYROLL\_COST\_ACCRUAL\_FLAG|VARCHAR2|1|||Indicates whether time card based costs can be accrued for this version and time period.||360Foreign Keys361 362|**Table**|**Foreign Table**|**Foreign Key Column**|363| :- | :- | :- |364|PJC\_ALLOC\_RULES\_ALL|pjf\_system\_linkages|TARGET\_EXP\_TYPE\_CLASS|365|PJC\_ALLOC\_RULES\_ALL|pjf\_exp\_types\_b|TARGET\_EXP\_TYPE\_ID|366|PJC\_ALLOC\_RULES\_ALL|pjf\_rbs\_headers\_b|ALLOC\_RBS\_HEADER\_ID|367|PJC\_ALLOC\_RULES\_ALL|pjf\_system\_linkages|OFFSET\_EXP\_TYPE\_CLASS|368|PJC\_ALLOC\_RULES\_ALL|pjf\_exp\_types\_b|OFFSET\_EXP\_TYPE\_ID|369|PJC\_ALLOC\_RULES\_ALL|pjf\_projects\_all\_b|OFFSET\_PROJECT\_ID|370|PJC\_ALLOC\_RULES\_ALL|pjf\_proj\_elements\_b|OFFSET\_TASK\_ID|371|PJC\_ALLOC\_RULES\_ALL|pjf\_rbs\_headers\_b|BASIS\_RBS\_HEADER\_ID|372|PJC\_ALLOC\_RULES\_ALL|pjo\_plan\_types\_b|BASIS\_FIN\_PLAN\_TYPE\_ID|373|pjc\_alloc\_gl\_lines|pjc\_alloc\_rules\_all|RULE\_ID|374|pjc\_ld\_sch\_target\_lines|pjc\_alloc\_rules\_all|RULE\_ID|375|pjc\_alloc\_target\_lines|pjc\_alloc\_rules\_all|RULE\_ID|376|pjc\_alloc\_resources|pjc\_alloc\_rules\_all|RULE\_ID|377|pjc\_alloc\_run\_res\_det|pjc\_alloc\_rules\_all|RULE\_ID|378|pjc\_alloc\_source\_lines|pjc\_alloc\_rules\_all|RULE\_ID|379 380Indexes381 382|**Index**|**Uniqueness**|**Tablespace**|**Columns**|383| :- | :- | :- | :- |384|PJC\_ALLOC\_RULES\_ALL\_N1|Non Unique|Default|PERSON\_ID, ASSIGNMENT\_ID, ELEMENT\_TYPE\_ID|385|PJC\_ALLOC\_RULES\_ALL\_N2|Non Unique|Default|ORG\_ID, ALLOCATION\_GROUP\_NAME|386|PJC\_ALLOC\_RULES\_ALL\_N3|Non Unique|Default|ELEMENT\_TYPE\_ID, ORG\_ID|387|PJC\_ALLOC\_RULES\_ALL\_N4|Non Unique|Default|RULE\_HDR\_ID|388|PJC\_ALLOC\_RULES\_ALL\_U1|Unique|Default|RULE\_ID|389|PJC\_ALLOC\_RULES\_ALL\_U2|Unique|Default|RULE\_NAME|390 391PJC\_ALLOC\_RUNS\_ALL392 393PA\_ALLOC\_RUNS\_ALL stores all the information for an allocation run.394 395Details396 397- Schema: FUSION398- Object owner: PJC399- Object type: TABLE400- Tablespace: APPS\_TS\_TX\_DATA401 402Primary Key403 404|**Name**|**Columns**|405| :- | :- |406|PJC\_ALLOC\_RUNS\_ALL\_PK|RUN\_ID|407 408Columns409 410|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|411| :- | :- | :- | :- | :- | :- |412|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|413|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|414|RUN\_PERIOD|VARCHAR2|20|||Run period name|415|EXPND\_ITEM\_DATE|DATE|||Yes|Expenditure item date for an allocation run|416|DENOM\_CURRENCY\_CODE|VARCHAR2|15||Yes|Denomination currency code|417|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|418|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|419|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|420|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|421|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|422|FIXED\_AMOUNT|NUMBER||||Fixed amount|423|POOL\_PERCENT|NUMBER||||Allocation percentage specified at rule level|424|PERIOD\_TYPE|VARCHAR2|2|||Period type of GL (General Ledger) or PA (Oracle Projects)|425|SOURCE\_AMOUNT\_TYPE|VARCHAR2|4|||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|426|SOURCE\_BALANCE\_CATEGORY|VARCHAR2|1|||Source balance category. It can only be A(actuals)|427|SOURCE\_BALANCE\_TYPE|VARCHAR2|30|||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|428|ALLOC\_RBS\_HEADER\_ID|NUMBER||18||Alloc RBS Header Id \*\*\*\*\*|429|AUTO\_RELEASE\_FLAG|VARCHAR2|1|||The flag indicates whether to create expenditure items automatically. Y means release automatically|430|ALLOCATION\_METHOD|VARCHAR2|1|||Allocation method. It can be F(full) or I(incremental)|431|DUP\_TARGETS\_FLAG|VARCHAR2|1|||The flag indicates whether to allow duplicate target projects and tasks.Y means to allow duplicate target projects and tasks|432|TARGET\_EXP\_TYPE\_CLASS|VARCHAR2|30|||Expenditure type class of allocation transactions|433|TARGET\_EXP\_ORG\_ID|NUMBER||18||Expenditure organization of allocation transactions|434|TARGET\_EXP\_TYPE\_ID|NUMBER||18||Expenditure type of allocation transactions \*\*\*\*\*|435|TARGET\_COST\_TYPE|VARCHAR2|1|||Cost type of allocation transactions. It can be R (raw) or B (burdened)|436|OFFSET\_EXP\_TYPE\_CLASS|VARCHAR2|30|||Expenditure type class of offset transactions|437|OFFSET\_EXP\_ORG\_ID|NUMBER||18||Expenditure organization id of offset transactions|438|OFFSET\_EXP\_TYPE\_ID|NUMBER||18||Expenditure type of allocation transactions \*\*\*\*\*|439|OFFSET\_COST\_TYPE|VARCHAR2|1|||Cost type of offset transactions. It can be B (burdened) or R (raw)|440|OFFSET\_METHOD|VARCHAR2|1|||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)|441|OFFSET\_PROJECT\_ID|NUMBER||18||Offset project id|442|OFFSET\_TASK\_ID|NUMBER||18||Offset task id|443|RUN\_STATUS|VARCHAR2|3|||Allocation run status. It can be DF (draft failure) , DS (draft success), RF (release failure), RV (run reverse) or RS (release success)|444|BASIS\_METHOD|VARCHAR2|2|||Basis method. It can be S(spread evenly) ,P(prorated),C(client extension),FS(fixed and spread evenly) or FP(fixed and prorated)|445|BASIS\_RELATIVE\_PERIOD|NUMBER||||Relative basis period|446|BASIS\_AMOUNT\_TYPE|VARCHAR2|4|||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|447|BASIS\_BALANCE\_CATEGORY|VARCHAR2|1|||Basis balance category. it can be A (actuals) or B (budgets)|448|BASIS\_BALANCE\_TYPE|VARCHAR2|30|||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|449|BASIS\_RBS\_HEADER\_ID|NUMBER||18||Basis RBS Header Id \*\*\*\*\*|450|FISCAL\_YEAR|NUMBER||||Fiscal year of the run period|451|QUARTER|NUMBER||||Quarter number of the run period|452|PERIOD\_NUM|NUMBER||||Period number|453|TARGET\_EXP\_GROUP\_ID|NUMBER||18||Target Exp Group Id \*\*\*\*\*|454|TOTAL\_POOL\_AMOUNT|NUMBER||||Total source pool amount|455|ALLOCATED\_AMOUNT|NUMBER||||Allocated amount|456|TOTAL\_ALLOCATED\_AMOUNT|NUMBER||||Total allocated amount|457|TOTAL\_OFFSETTED\_AMOUNT|NUMBER||||Total offsetted amount|458|MISSING\_SOURCE\_PROJ\_AMT|NUMBER||||Missing source project amount|459|MISSING\_TARGET\_PROJ\_AMT|NUMBER||||Missing target project amount|460|MISSING\_OFFSET\_PROJ\_AMT|NUMBER||||Missing offset project amount|461|REVERSAL\_DATE|DATE||||Reversal date if the run is reversed|462|DRAFT\_REQUEST\_ID|NUMBER||18||Request id for the draft allocation run|463|DRAFT\_REQUEST\_DATE|DATE||||Creation date of request for a draft allocation|464|RELEASE\_REQUEST\_ID|NUMBER||18||Request id for the release allocation run|465|RELEASE\_REQUEST\_DATE|DATE||||Creation date of request for a release allocation|466|ORG\_ID|NUMBER||18|Yes|Indicates the identifier of the business unit associated to the row.|467|LIMIT\_TARGET\_PROJECTS\_CODE|VARCHAR2|1||Yes|Buiseness organization level code that limits the selection of target projects.|468|BASIS\_FIN\_PLAN\_TYPE\_ID|NUMBER||18||Fin plan type populated when allocation basis is Fin Plan|469|CINT\_RATE\_NAME\_ID|NUMBER||18||Interest rate name ID of the Transaction run.|470|ALLOC\_RBS\_VERSION|NUMBER||||RBS structure version for allocation source resources.|471|BASIS\_RBS\_VERSION|NUMBER||||RBS structure version for allocation basis resources.|472|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|473|JOB\_DEFINITION\_NAME|VARCHAR2|100|||Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.|474|JOB\_DEFINITION\_PACKAGE|VARCHAR2|900|||Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.|475|SUB\_REQUEST\_ID|NUMBER||18||Sub request ID for the parallelization process.|476|DELETE\_FLAG|VARCHAR2|1|||Indicate this run record needs to be deleted.|477|LD\_INTERFACE\_ID|NUMBER||18||Primary key from the table PJC\_LD\_XFACT\_INT.|478|BC\_PASS\_FLAG|VARCHAR2|1|||Indicate budget check status.|479|PRIOR\_REQUEST\_ID|NUMBER||18||Prior request ID.|480|LD\_BATCH\_NAME|VARCHAR2|200|||Name of the payroll batch imported from the payroll system.|481|LD\_PERIOD\_START\_DATE|DATE||||Start date of the payroll period for the person.|482|LD\_PERIOD\_END\_DATE|DATE||||End date of the payroll period for the person.|483|LD\_PERSON\_ID|NUMBER||18||Person ID related to the person record for this labor schedule.|484|LD\_ELEMENT\_TYPE|VARCHAR2|80|||Name of the pay element for the person.|485|LD\_ASSIGNMENT\_ID|NUMBER||18||Assignment ID related to the assignment record for this labor schedule.|486|LD\_ORIG\_TRANSACTION\_REFERENCE|VARCHAR2|120|||Unique identifier of this record in the payroll system.|487|PROCESSING\_START\_DATE|DATE||||Processing start date.|488|PROCESSING\_END\_DATE|DATE||||Processing end date.|489|LD\_DAILY\_RATE|NUMBER||||Person assignment daily rate.|490|REVERSE\_REQUEST\_ID|NUMBER||18||Reversal request ID.|491|BASIS\_RELATIVE\_FISCAL\_YEAR|NUMBER||||Derived fiscal year based on the relative basis period.|492|BASIS\_RELATIVE\_QUARTER\_NUM|NUMBER||||Derived quarter number based on the relative basis period.|493|BASIS\_RELATIVE\_PERIOD\_NUM|NUMBER||||Derived period number based on the relative basis period.|494|BASIS\_RELATIVE\_PERIOD\_NAME|VARCHAR2|20|||Derived period name based on the relative basis period.|495|BASIS\_RELATIVE\_START\_DATE|DATE||||Derived basis period start date based on the relative basis period.|496|BASIS\_RELATIVE\_END\_DATE|DATE||||Derived basis period end date based on the relative basis period.|497|PRIOR\_OFFSET\_AMOUNT|NUMBER||||Total prior offset allocation amount for a given rule.|498|NO\_BASIS\_AMOUNT\_FLAG|VARCHAR2|1|||Error flag indicating no basis amount exists.|499|OVERRIDEN\_BASIS\_METHOD|VARCHAR2|20|||Overridden basis method if no basis exists and the profile Allocation Method for Zero-Basis Amounts is set to Spread Evenly.|500|LD\_ELEMENT\_TYPE\_ID|NUMBER||18||Pay element type ID.|501|TOTAL\_PRIOR\_ALLOC\_AMOUNT|NUMBER||||Total cost allocated in the prior run.|502|REMNANT\_AMOUNT|NUMBER||||Fractional amount that was not naturally allocated in the current run. This amount will get added to one of the targets, typically the largest target, to ensure the allocation is in balance.|503|PAYROLL\_LOAD\_REQUEST\_ID|NUMBER||18||The Oracle Payroll request identifier used to load data into the Oracle Labor Distribution interface table.|504|DOCUMENT\_ID|NUMBER||18||The unique identifier of the transaction document that defines the source of the Labor Distribution interface data.|505|PAYROLL\_ID|NUMBER||18||The payroll identifier associated with the interfaced cost.|506|PAYROLL\_NAME|VARCHAR2|80|||The name of the payroll associated with the interfaced cost.|507|OCCUR\_PAY\_PERIOD\_START\_DATE|DATE||||The start date of the payroll period during which the cost was generated.|508|OCCUR\_PAY\_PERIOD\_END\_DATE|DATE||||The end date of the payroll period during which the cost was generated.|509|PAYROLL\_EFFECTIVE\_DATE|DATE||||The date the payroll cost was generated.|510|PAYROLL\_REL\_ACTION\_ID|NUMBER||18||The unique payroll relationship identifier of the cost. This identifier is used to gather accounting information associated with the cost.|511|COST\_ACTION\_TYPE|VARCHAR2|30|||The unique payroll action identifier of the cost. This identifier is used to gather accounting information associated with the cost.|512|COST\_ID|NUMBER||18||The unique identifier of the cost. This identifier is used to gather accounting information associated with the cost.|513|COST\_ALLOCATION\_KEYFLEX\_ID|NUMBER||18||The unique identifier of the cost allocation flex field associated with the cost.|514|COST\_ACTION\_ID|NUMBER||18||The unique identifier of the payroll cost action used to get accounting information associated with the cost.|515|RUN\_ACTION\_ID|NUMBER||18||The unique identifier of the payroll run action used to get accounting information associated with the cost.|516|NET\_ZERO\_ADJUSTMENT\_FLAG|VARCHAR2|1|||Flag that indicates whether the run is fully reversed.|517|TIMECARD\_DIST\_BASIS|VARCHAR2|30|||The basis that determines which time cards are eligible when distributing costs for the project pay element to time cards.|518|TIMECARD\_RUN\_STATUS|VARCHAR2|30|||Run status for the distribution of payroll costs to time cards.|519|TIMECARD\_REPROCESS\_FLAG|VARCHAR2|1|||Flag that indicates whether a payroll cost that was previously distributed to time cards needs to be reprocessed due to a change in the total target time card quantities.|520 521Foreign Keys522 523|**Table**|**Foreign Table**|**Foreign Key Column**|524| :- | :- | :- |525|PJC\_ALLOC\_RUNS\_ALL|pjo\_plan\_types\_b|BASIS\_FIN\_PLAN\_TYPE\_ID|526|pjc\_alloc\_exceptions|pjc\_alloc\_runs\_all|RUN\_ID|527|pjc\_alloc\_txn\_details|pjc\_alloc\_runs\_all|RUN\_ID|528|pjc\_alloc\_run\_source\_det|pjc\_alloc\_runs\_all|RUN\_ID|529|pjc\_alloc\_missing\_costs|pjc\_alloc\_runs\_all|RUN\_ID|530|pjc\_alloc\_run\_res\_det|pjc\_alloc\_runs\_all|RUN\_ID|531 532Indexes533 534|**Index**|**Uniqueness**|**Tablespace**|**Columns**|535| :- | :- | :- | :- |536|PJC\_ALLOC\_RUNS\_ALL\_N3|Non Unique|Default|RUN\_PERIOD|537|PJC\_ALLOC\_RUNS\_ALL\_N4|Non Unique|Default|SUB\_REQUEST\_ID|538|PJC\_ALLOC\_RUNS\_ALL\_N5|Non Unique|Default|RELEASE\_REQUEST\_ID|539|PJC\_ALLOC\_RUNS\_ALL\_N6|Non Unique|Default|LD\_ORIG\_TRANSACTION\_REFERENCE|540|PJC\_ALLOC\_RUNS\_ALL\_N7|Non Unique|Default|LD\_PERSON\_ID|541|PJC\_ALLOC\_RUNS\_ALL\_N8|Non Unique|Default|LD\_BATCH\_NAME|542|PJC\_ALLOC\_RUNS\_ALL\_N9|Non Unique|Default|LD\_INTERFACE\_ID|543|PJC\_ALLOC\_RUNS\_N1|Non Unique|Default|DRAFT\_REQUEST\_ID|544|PJC\_ALLOC\_RUNS\_N2|Non Unique|Default|RULE\_ID, FISCAL\_YEAR, QUARTER, PERIOD\_NUM|545|PJC\_ALLOC\_RUNS\_U1|Unique|Default|RUN\_ID|546 547PJC\_ALLOC\_RUN\_BASIS\_DET548 549PA\_ALLOC\_RUN\_BASIS\_DET stores basis information for an allocation run.550 551Details552 553- Schema: FUSION554- Object owner: PJC555- Object type: TABLE556- Tablespace: APPS\_TS\_TX\_DATA557 558Primary Key559 560|**Name**|**Columns**|561| :- | :- |562|PJC\_ALLOC\_RUN\_BASIS\_DET\_PK|RUN\_BASIS\_DET\_ID|563 564Columns565 566|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|567| :- | :- | :- | :- | :- | :- |568|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|569|RUN\_BASIS\_DET\_ID|NUMBER||18|Yes|New column added for primary key \*\*\*\*\*|570|RULE\_ID|NUMBER||18|Yes|'Allocation rule identification number|571|LINE\_NUM|NUMBER|||Yes|Line Number|572|PROJECT\_ID|NUMBER||18|Yes|Project identifier|573|TASK\_ID|NUMBER||18|Yes|Task identifier|574|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|575|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|576|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|577|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|578|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|579|AMOUNT|NUMBER||||Basis Amount|580|BASIS\_PERCENT|NUMBER||||Percentage of calculated basis amount in total line amount|581|RBS\_ELEMENT\_ID|NUMBER||18||RBS Element Id \*\*\*\*\*|582|LINE\_PERCENT|NUMBER||||Allocation percentage specified at the target line level|583|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|584 585Foreign Keys586 587|**Table**|**Foreign Table**|**Foreign Key Column**|588| :- | :- | :- |589|PJC\_ALLOC\_RUN\_BASIS\_DET|pjf\_rbs\_elements|RBS\_ELEMENT\_ID|590|PJC\_ALLOC\_RUN\_BASIS\_DET|pjf\_proj\_elements\_b|TASK\_ID|591 592Indexes593 594|**Index**|**Uniqueness**|**Tablespace**|**Columns**|595| :- | :- | :- | :- |596|PJC\_ALLOC\_RUN\_BASIS\_DET\_N1|Non Unique|Default|RUN\_ID, LINE\_NUM, PROJECT\_ID, TASK\_ID|597|PJC\_ALLOC\_RUN\_BASIS\_DET\_U1|Unique|Default|RUN\_BASIS\_DET\_ID|598 599PJC\_ALLOC\_RUN\_GL\_DET600 601PA\_ALLOC\_RUN\_GL\_DET stores source lines that are related to GL accounts for each allocation run.602 603Details604 605- Schema: FUSION606- Object owner: PJC607- Object type: TABLE608- Tablespace: APPS\_TS\_TX\_DATA609 610Primary Key611 612|**Name**|**Columns**|613| :- | :- |614|PJC\_ALLOC\_RUN\_GL\_DET\_PK|RUN\_GL\_DET\_ID|615 616Columns617 618|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|619| :- | :- | :- | :- | :- | :- |620|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|621|RUN\_GL\_DET\_ID|NUMBER||18|Yes|New column addded for primary key \*\*\*\*\*|622|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|623|LINE\_NUM|NUMBER|||Yes|Line Number|624|SOURCE\_CCID|NUMBER||18|Yes|Code combination id for GL account|625|SUBTRACT\_FLAG|VARCHAR2|1||Yes|The flag indicates whether the GL account balance is subtracted. Y means subtracted|626|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|627|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|628|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|629|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|630|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|631|SOURCE\_PERCENT|NUMBER||||Percentage of account balance to be considered|632|AMOUNT|NUMBER||||Amount|633|ELIGIBLE\_AMOUNT|NUMBER||||Eligible\_amount=amount\*source\_percent|634|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|635 636Foreign Keys637 638|**Table**|**Foreign Table**|**Foreign Key Column**|639| :- | :- | :- |640|PJC\_ALLOC\_RUN\_GL\_DET|pjc\_alloc\_gl\_lines|RULE\_ID, LINE\_NUM|641|PJC\_ALLOC\_RUN\_GL\_DET|gl\_code\_combinations|SOURCE\_CCID|642 643Indexes644 645|**Index**|**Uniqueness**|**Tablespace**|**Columns**|646| :- | :- | :- | :- |647|PJC\_ALLOC\_RUN\_GL\_DET\_N1|Non Unique|Default|RUN\_ID, LINE\_NUM, SOURCE\_CCID|648|PJC\_ALLOC\_RUN\_GL\_DET\_U1|Unique|Default|RUN\_GL\_DET\_ID|649 650PJC\_ALLOC\_RUN\_RES\_DET651 652Transaction Table created to store the Resource List Member Details for an allocation run.653 654Details655 656- Schema: FUSION657- Object owner: PJC658- Object type: TABLE659- Tablespace: APPS\_TS\_TX\_DATA660 661Primary Key662 663|**Name**|**Columns**|664| :- | :- |665|PJC\_ALLOC\_RUN\_RES\_DET\_PK|RUN\_RES\_DET\_ID|666 667Columns668 669|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|670| :- | :- | :- | :- | :- | :- |671|RULE\_ID|NUMBER||18|Yes|Allocation Rule Identification Number|672|RUN\_RES\_DET\_ID|NUMBER||18|Yes|New column added for primary key \*\*\*\*\*|673|RUN\_ID|NUMBER||18|Yes|Allocation Run Identification Number|674|MEMBER\_TYPE|VARCHAR2|1||Yes|Resource List member type|675|RBS\_ELEMENT\_ID|NUMBER||18|Yes|The Identifier of the resource element \*\*\*\*\*|676|RESOURCE\_PERCENT|NUMBER||||Resource Utilization percentage|677|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|678|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|679|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|680|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|681|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|682|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|683|EXCLUDE\_FLAG|VARCHAR2|1|||Flag indicating that the specific resource element is to be excluded as an allocation calculation.|684 685Foreign Keys686 687|**Table**|**Foreign Table**|**Foreign Key Column**|688| :- | :- | :- |689|PJC\_ALLOC\_RUN\_RES\_DET|pjc\_alloc\_rules\_all|RULE\_ID|690|PJC\_ALLOC\_RUN\_RES\_DET|pjc\_alloc\_runs\_all|RUN\_ID|691|PJC\_ALLOC\_RUN\_RES\_DET|pjf\_rbs\_elements|RBS\_ELEMENT\_ID|692 693Indexes694 695|**Index**|**Uniqueness**|**Tablespace**|**Columns**|696| :- | :- | :- | :- |697|PJC\_ALLOC\_RUN\_RES\_DET\_U1|Unique|Default|RUN\_ID, RBS\_ELEMENT\_ID, MEMBER\_TYPE|698|PJC\_ALLOC\_RUN\_RES\_DET\_U2|Unique|Default|RUN\_RES\_DET\_ID|699 700PJC\_ALLOC\_RUN\_SOURCES701 702PA\_ALLOC\_RUN\_SOURCES stores temporary records for each allocation run about all source projects and tasks generated by each source line.703 704Details705 706- Schema: FUSION707- Object owner: PJC708- Object type: TABLE709- Tablespace: APPS\_TS\_TX\_DATA710 711Primary Key712 713|**Name**|**Columns**|714| :- | :- |715|PJC\_ALLOC\_RUN\_SOURCES\_PK|RUN\_SOURCE\_ID|716 717Columns718 719|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|720| :- | :- | :- | :- | :- | :- |721|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|722|RUN\_SOURCE\_ID|NUMBER||18|Yes|New column added for primary key \*\*\*\*\*|723|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|724|LINE\_NUM|NUMBER|||Yes|Line number of the source line|725|PROJECT\_ID|NUMBER||18|Yes|Project identifier|726|EXCLUDE\_FLAG|VARCHAR2|1||Yes|The flag indicates whether to exclude returned projects. Y means to exclude|727|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|728|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|729|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|730|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|731|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|732|TASK\_ID|NUMBER||18||Task id|733|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|734|CONTRACT\_ID|NUMBER||18||Contract\_id|735|FUNDING\_SOURCE\_ID|NUMBER||18||Funding Source Id|736 737Foreign Keys738 739|**Table**|**Foreign Table**|**Foreign Key Column**|740| :- | :- | :- |741|PJC\_ALLOC\_RUN\_SOURCES|pjc\_alloc\_source\_lines|RULE\_ID, LINE\_NUM|742 743Indexes744 745|**Index**|**Uniqueness**|**Tablespace**|**Columns**|746| :- | :- | :- | :- |747|PJC\_ALLOC\_RUN\_SOURCES\_N1|Non Unique|Default|RUN\_ID, EXCLUDE\_FLAG, PROJECT\_ID, TASK\_ID|748|PJC\_ALLOC\_RUN\_SOURCES\_N2|Non Unique|Default|PROJECT\_ID|749|PJC\_ALLOC\_RUN\_SOURCES\_N3|Non Unique|Default|TASK\_ID|750|PJC\_ALLOC\_RUN\_SOURCES\_U1|Unique|Default|RUN\_SOURCE\_ID|751 752PJC\_ALLOC\_RUN\_SOURCE\_DET753 754PA\_ALLOC\_RUN\_SOURCE\_DET stores source amount details for each source project and task (and by resources, if source resources were defined) for each allocation run.755 756Details757 758- Schema: FUSION759- Object owner: PJC760- Object type: TABLE761- Tablespace: APPS\_TS\_TX\_DATA762 763Primary Key764 765|**Name**|**Columns**|766| :- | :- |767|PJC\_ALLOC\_RUN\_SOURCE\_DET\_PK|RUN\_SOURCE\_DET\_ID|768 769Columns770 771|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|772| :- | :- | :- | :- | :- | :- |773|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|774|RUN\_SOURCE\_DET\_ID|NUMBER||18|Yes|New column added for primary key \*\*\*\*\*|775|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|776|LINE\_NUM|NUMBER|||Yes|Line Number of the source line|777|PROJECT\_ID|NUMBER||18||Project ID|778|TASK\_ID|NUMBER||18||Task ID|779|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|780|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|781|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|782|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|783|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|784|RBS\_ELEMENT\_ID|NUMBER||18||RBS Element Id \*\*\*\*\*|785|AMOUNT|NUMBER||||Amount|786|RESOURCE\_PERCENT|NUMBER||||Percentage of allocation at resource line level|787|ELIGIBLE\_AMOUNT|NUMBER||||Eligible amount=amount\*Resource%|788|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|789|CONTRACT\_ID|NUMBER||18||Contract Id|790|FUNDING\_SOURCE\_ID|NUMBER||18||Funding Source Id|791|PRIOR\_OFFSET\_AMOUNT|NUMBER||||Prior offset allocation amount for a given period.|792|PRIOR\_OFFSET\_CALCULATED\_FLAG|VARCHAR2|1|||Flag indicating that prior offset amount has been calculated for a given source.|793 794Foreign Keys795 796|**Table**|**Foreign Table**|**Foreign Key Column**|797| :- | :- | :- |798|PJC\_ALLOC\_RUN\_SOURCE\_DET|pjc\_alloc\_runs\_all|RUN\_ID|799 800Indexes801 802|**Index**|**Uniqueness**|**Tablespace**|**Columns**|803| :- | :- | :- | :- |804|PJC\_ALLOC\_RUN\_SOURCE\_DET\_N1|Non Unique|Default|RUN\_ID, LINE\_NUM, PROJECT\_ID, TASK\_ID|805|PJC\_ALLOC\_RUN\_SOURCE\_DET\_U1|Unique|Default|RUN\_SOURCE\_DET\_ID|806 807PJC\_ALLOC\_RUN\_TARGETS808 809PA\_ALLOC\_RUN\_TARGETS stores temporary records for each allocation run about all target projects and tasks generated by each target line.810 811Details812 813- Schema: FUSION814- Object owner: PJC815- Object type: TABLE816- Tablespace: APPS\_TS\_TX\_DATA817 818Primary Key819 820|**Name**|**Columns**|821| :- | :- |822|PJC\_ALLOC\_RUN\_TARGETS\_PK|RUN\_TARGET\_ID|823 824Columns825 826|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|827| :- | :- | :- | :- | :- | :- |828|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|829|RUN\_TARGET\_ID|NUMBER||18|Yes|New column added for primary key \*\*\*\*\*|830|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|831|LINE\_NUM|NUMBER|||Yes|Line Number of the target line|832|PROJECT\_ID|NUMBER||18||Project ID|833|EXCLUDE\_FLAG|VARCHAR2|1||Yes|The flag indicates whether to exclude returned projects. Y means to exclude|834|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|835|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|836|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|837|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|838|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|839|TASK\_ID|NUMBER||18||Task ID|840|LINE\_PERCENT|NUMBER||||Allocation percentage specified at the target line level|841|PLAN\_VERSION\_ID|NUMBER||18||Plant versions populated when basis is fin plan \*\*\*\*\*|842|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|843|CONTRACT\_ID|NUMBER||18||Contract Id.|844|LD\_TARGET\_CCID|NUMBER||18||GL account to which the cost will be distributed based on the line percent.|845|LD\_SUSPENSE\_ACCT\_FLAG|VARCHAR2|1|||Suspense account flag.|846|CONTEXT\_CATEGORY|VARCHAR2|40|||Segment used to identify the descriptive flexfield application context for project-related standardized cost collection.|847|EXPENDITURE\_TYPE\_ID|NUMBER||18||Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions.|848|EXPENDITURE\_ITEM\_DATE|DATE||||Date on which a project-related transaction is incurred.|849|ORGANIZATION\_ID|NUMBER||18||Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions.|850|BILLABLE\_FLAG|VARCHAR2|1|||Flag that indicates if a project-related item is available to be billed to customers.|851|CAPITALIZABLE\_FLAG|VARCHAR2|1|||Flag that indicates if a project-related item is eligible for capitalization.|852|WORK\_TYPE\_ID|NUMBER||18||Identifier for project-related classification of the worked performed.|853|CONTRACT\_LINE\_ID|NUMBER||18||Tracks contract line information. Not used currently.|854|FUNDING\_ALLOCATION\_ID|NUMBER||18||Specifies the name of the project funding override. Not used currently.|855|RESERVED\_ATTRIBUTE1|VARCHAR2|150|||Reserved for funding source, external or internal, funding the sponsored project.|856|RESERVED\_ATTRIBUTE2|VARCHAR2|150|||Reserved for future project-related functionality.|857|RESERVED\_ATTRIBUTE3|VARCHAR2|150|||Reserved for future project-related functionality.|858|RESERVED\_ATTRIBUTE4|VARCHAR2|150|||Reserved for future project-related functionality.|859|RESERVED\_ATTRIBUTE5|VARCHAR2|150|||Reserved for future project-related functionality.|860|RESERVED\_ATTRIBUTE6|VARCHAR2|150|||Reserved for future project-related functionality.|861|RESERVED\_ATTRIBUTE7|VARCHAR2|150|||Reserved for future project-related functionality.|862|RESERVED\_ATTRIBUTE8|VARCHAR2|150|||Reserved for future project-related functionality.|863|RESERVED\_ATTRIBUTE9|VARCHAR2|150|||Reserved for future project-related functionality.|864|RESERVED\_ATTRIBUTE10|VARCHAR2|150|||Reserved for future project-related functionality.|865|USER\_DEF\_ATTRIBUTE1|VARCHAR2|150|||Reserved for user-definable project information.|866|USER\_DEF\_ATTRIBUTE2|VARCHAR2|150|||Reserved for user-definable project information.|867|USER\_DEF\_ATTRIBUTE3|VARCHAR2|150|||Reserved for user-definable project information.|868|USER\_DEF\_ATTRIBUTE4|VARCHAR2|150|||Reserved for user-definable project information.|869|USER\_DEF\_ATTRIBUTE5|VARCHAR2|150|||Reserved for user-definable project information.|870|USER\_DEF\_ATTRIBUTE6|VARCHAR2|150|||Reserved for user-definable project information.|871|USER\_DEF\_ATTRIBUTE7|VARCHAR2|150|||Reserved for user-definable project information.|872|USER\_DEF\_ATTRIBUTE8|VARCHAR2|150|||Reserved for user-definable project information.|873|USER\_DEF\_ATTRIBUTE9|VARCHAR2|150|||Reserved for user-definable project information.|874|USER\_DEF\_ATTRIBUTE10|VARCHAR2|150|||Reserved for user-definable project information.|875|REVERSAL\_RUN\_TARGET\_ID|NUMBER||18||Reversal run target ID which the current run target applies.|876|BUDGETARY\_CONTROL\_VAL\_STATUS|VARCHAR2|30|||Budgetary control validation status at the transaction level.|877|BASIS\_FACTOR|NUMBER||||Derived basis factor used to prorate cost allocation.|878|PRIOR\_ALLOCATION\_AMOUNT|NUMBER||||Prior allocation amount for the source project and task.|879|PRIOR\_ALLOC\_CALCULATED\_FLAG|VARCHAR2|1|||Flag indicating that prior allocation amount has been calculated for a given target.|880|NO\_BASIS\_AMOUNT\_FLAG|VARCHAR2|1|||Error flag indicating no basis amount exists.|881|TIMECARD\_DIST\_FLAG|VARCHAR2|1|||Indicates that this is a time card based distribution.|882 883Foreign Keys884 885|**Table**|**Foreign Table**|**Foreign Key Column**|886| :- | :- | :- |887|PJC\_ALLOC\_RUN\_TARGETS|pjc\_alloc\_target\_lines|RULE\_ID, LINE\_NUM|888|PJC\_ALLOC\_RUN\_TARGETS|pjo\_plan\_versions\_b|PLAN\_VERSION\_ID|889 890Indexes891 892|**Index**|**Uniqueness**|**Tablespace**|**Columns**|893| :- | :- | :- | :- |894|PJC\_ALLOC\_RUN\_TARGETS\_N1|Non Unique|Default|RUN\_ID, EXCLUDE\_FLAG, PROJECT\_ID, TASK\_ID|895|PJC\_ALLOC\_RUN\_TARGETS\_N2|Non Unique|Default|PROJECT\_ID|896|PJC\_ALLOC\_RUN\_TARGETS\_N3|Non Unique|Default|TASK\_ID|897|PJC\_ALLOC\_RUN\_TARGETS\_N4|Non Unique|Default|CONTRACT\_ID|898|PJC\_ALLOC\_RUN\_TARGETS\_U1|Unique|Default|RUN\_TARGET\_ID|899 900PJC\_ALLOC\_SOURCE\_LINES901 902PA\_ALLOC\_SOURCE\_LINES stores source lines for each allocation rule.903 904Details905 906- Schema: FUSION907- Object owner: PJC908- Object type: TABLE909- Tablespace: APPS\_TS\_TX\_DATA910 911Primary Key912 913|**Name**|**Columns**|914| :- | :- |915|PJC\_ALLOC\_SOURCE\_PK|RULE\_ID, LINE\_NUM|916 917Columns918 919|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|920| :- | :- | :- | :- | :- | :- |921|RULE\_ID|NUMBER||18|Yes|Unique identifier for an allocation rule for the source line|922|LINE\_NUM|NUMBER|||Yes|Line number|923|EXCLUDE\_FLAG|VARCHAR2|1||Yes|The flag indicates whether to exclude returned projects Y means exclude|924|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|925|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|926|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|927|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|928|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|929|PROJECT\_ORG\_ID|NUMBER||18||Project organization id|930|TASK\_ORG\_ID|NUMBER||18||Task organization id|931|PROJECT\_TYPE\_ID|NUMBER||18||Project Type Id \*\*\*\*\*|932|SERVICE\_TYPE|VARCHAR2|30|||Service type|933|PROJECT\_ID|NUMBER||18||Project id|934|TASK\_ID|NUMBER||18||Task id|935|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|936|CLASS\_CODE\_ID|NUMBER||18||Class Code ID|937|CLASS\_CATEGORY\_ID|NUMBER||18||Class Category ID|938|CONTRACT\_ID|NUMBER||18||Contract ID|939|FUNDING\_SOURCE\_ID|NUMBER||18||Fundung Source ID|940 941Foreign Keys942 943|**Table**|**Foreign Table**|**Foreign Key Column**|944| :- | :- | :- |945|PJC\_ALLOC\_SOURCE\_LINES|pjf\_projects\_all\_b|PROJECT\_ID|946|PJC\_ALLOC\_SOURCE\_LINES|pjf\_proj\_elements\_b|TASK\_ID|947|PJC\_ALLOC\_SOURCE\_LINES|pjc\_alloc\_rules\_all|RULE\_ID|948|pjc\_alloc\_run\_sources|pjc\_alloc\_source\_lines|RULE\_ID, LINE\_NUM|949 950Indexes951 952|**Index**|**Uniqueness**|**Tablespace**|**Columns**|953| :- | :- | :- | :- |954|PJC\_ALLOC\_SOURCE\_LINES\_N1|Non Unique|Default|RULE\_ID, EXCLUDE\_FLAG|955|PJC\_ALLOC\_SOURCE\_LINES\_U1|Unique|Default|RULE\_ID, LINE\_NUM|956 957PJC\_ALLOC\_TARGET\_LINES958 959PA\_ALLOC\_TARGET\_LINES stores target lines for each allocation rule.960 961Details962 963- Schema: FUSION964- Object owner: PJC965- Object type: TABLE966- Tablespace: APPS\_TS\_TX\_DATA967 968Primary Key969 970|**Name**|**Columns**|971| :- | :- |972|PJC\_ALLOC\_TARGET\_PK|RULE\_ID, LINE\_NUM|973 974Columns975 976|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|977| :- | :- | :- | :- | :- | :- |978|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|979|LINE\_NUM|NUMBER|||Yes|Line Number of the target line|980|EXCLUDE\_FLAG|VARCHAR2|1||Yes|The flag indicates whether to exclude returned projects. Y means exclude|981|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|982|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|983|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|984|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|985|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|986|PROJECT\_ORG\_ID|NUMBER||18||Standard Who Column|987|TASK\_ORG\_ID|NUMBER||18||Task organiztation id|988|PROJECT\_TYPE\_ID|NUMBER||18||Project Type Id \*\*\*\*\*|989|SERVICE\_TYPE|VARCHAR2|30|||Service type|990|PROJECT\_ID|NUMBER||18||Project ID|991|TASK\_ID|NUMBER||18||Task ID|992|BILLABLE\_ONLY\_FLAG|VARCHAR2|1|||The flag indicates whether to pick up billable tasks or all tasks. Y means bill|993|LINE\_PERCENT|NUMBER||||Percentage of pool amount assigned to this target line|994|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|995|CLASS\_CATEGORY\_ID|NUMBER||18||Class Category ID|996|CLASS\_CODE\_ID|NUMBER||18||Class Code ID|997|CONTRACT\_ID|NUMBER||18||Contract Id|998|FUNDING\_SOURCE\_ID|NUMBER||18||Funding Source Id|999 1000Foreign Keys1001 1002|**Table**|**Foreign Table**|**Foreign Key Column**|1003| :- | :- | :- |1004|PJC\_ALLOC\_TARGET\_LINES|pjf\_projects\_all\_b|PROJECT\_ID|1005|PJC\_ALLOC\_TARGET\_LINES|pjf\_proj\_elements\_b|TASK\_ID|1006|PJC\_ALLOC\_TARGET\_LINES|pjc\_alloc\_rules\_all|RULE\_ID|1007|pjc\_alloc\_run\_targets|pjc\_alloc\_target\_lines|RULE\_ID, LINE\_NUM|1008 1009Indexes1010 1011|**Index**|**Uniqueness**|**Tablespace**|**Columns**|1012| :- | :- | :- | :- |1013|PJC\_ALLOC\_TARGET\_LINES\_N1|Non Unique|Default|RULE\_ID, EXCLUDE\_FLAG|1014|PJC\_ALLOC\_TARGET\_LINES\_U1|Unique|Default|RULE\_ID, LINE\_NUM|1015 1016PJC\_ALLOC\_TXN\_DETAILS1017 1018PA\_ALLOC\_TXN\_DETAILS stores target and offset transactions created by an allocation run.1019 1020Details1021 1022- Schema: FUSION1023- Object owner: PJC1024- Object type: TABLE1025- Tablespace: APPS\_TS\_TX\_DATA1026 1027Primary Key1028 1029|**Name**|**Columns**|1030| :- | :- |1031|PJC\_ALLOC\_TXN\_DETAILS\_PK|ALLOC\_TXN\_ID|1032 1033Columns1034 1035|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|1036| :- | :- | :- | :- | :- | :- |1037|ALLOC\_TXN\_ID|NUMBER||18|Yes|Allocation transaction id|1038|RUN\_ID|NUMBER||18|Yes|Allocation run identification number|1039|RULE\_ID|NUMBER||18|Yes|Allocation rule identification number|1040|RUN\_TARGET\_ID|NUMBER||18||Foreign Key to table pjc\_alloc\_run\_targets.run\_target\_id.|1041|TRANSACTION\_TYPE|VARCHAR2|1||Yes|Transactions type. It can be T (Allocation) or O(offset)|1042|FISCAL\_YEAR|NUMBER||||Fiscal year of the run period|1043|QUARTER\_NUM|NUMBER||||Quarter number of the run period|1044|PERIOD\_NUM|NUMBER||||Period number|1045|RUN\_PERIOD|VARCHAR2|20|||Run period|1046|LINE\_NUM|NUMBER|||Yes|Line number|1047|CREATION\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the creation of the row.|1048|CREATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who created the row.|1049|LAST\_UPDATE\_DATE|TIMESTAMP|||Yes|Who column: indicates the date and time of the last update of the row.|1050|LAST\_UPDATED\_BY|VARCHAR2|64||Yes|Who column: indicates the user who last updated the row.|1051|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|1052|PROJECT\_ID|NUMBER||18||Project id|1053|TASK\_ID|NUMBER||18||Task id|1054|TOTAL\_ALLOCATION|NUMBER||||Total amount to allocate|1055|PREVIOUS\_ALLOCATION|NUMBER||||Previous allocation amount|1056|CURRENT\_ALLOCATION|NUMBER||||Current allocation amount|1057|STATUS\_CODE|VARCHAR2|1|||Transactions status. It can be P (pending),R (rejected) or A (accepted)|1058|EXPENDITURE\_ITEM\_ID|NUMBER||18||Expenditure item id when expenditure item is created|1059|ATTRIBUTE\_CATEGORY|VARCHAR2|30|||Descriptive Flexfield: structure definition of the user descriptive flexfield.|1060|ATTRIBUTE1|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1061|ATTRIBUTE2|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1062|ATTRIBUTE3|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1063|ATTRIBUTE4|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1064|ATTRIBUTE5|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1065|ATTRIBUTE6|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1066|ATTRIBUTE7|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1067|ATTRIBUTE8|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1068|ATTRIBUTE9|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1069|ATTRIBUTE10|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1070|CINT\_SOURCE\_TASK\_ID|NUMBER||18||Task identifier from the source transaction|1071|CINT\_EXP\_ORG\_ID|NUMBER||18||Expenditure Organization Identifier for capitalized interest transactions.|1072|CINT\_RATE\_MULTIPLIER|NUMBER||||Interest rate multiplier used to create the interest transaction|1073|CINT\_PRIOR\_BASIS\_AMT|NUMBER||||The summarized prior basis amount used to create the interest transaction.|1074|CINT\_CURRENT\_BASIS\_AMT|NUMBER||||The summarized current basis amount used to create the interest transaction.|1075|IND\_RATE\_SCH\_REVISION\_ID|NUMBER||18||Revision Identifier of the Rate Schedule Revision for Capital Interest Rate Schedule Revisions|1076|OBJECT\_VERSION\_NUMBER|NUMBER||9|Yes|Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.|1077|EXPENDITURE\_TYPE\_ID|NUMBER||18||Expenditure Type Id for The expenditure type \*\*\*\*\*|1078|CONTRACT\_ID|NUMBER||18||Contract Id|1079|LD\_ADJUSTED\_ALLOC\_TXN\_ID|NUMBER||18||Adjustment Allocation ID which the current distribution applies.|1080|LD\_TARGET\_CCID|NUMBER||18||GL account to which the cost will be distributed based on the line percent.|1081|CONTEXT\_CATEGORY|VARCHAR2|40|||Segment used to identify the descriptive flexfield application context for project-related standardized cost collection.|1082|EXPENDITURE\_ITEM\_DATE|DATE||||Date on which a project-related transaction is incurred.|1083|ORGANIZATION\_ID|NUMBER||18||Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions.|1084|BILLABLE\_FLAG|VARCHAR2|1|||Flag that indicates if a project-related item is available to be billed to customers.|1085|CAPITALIZABLE\_FLAG|VARCHAR2|1|||Flag that indicates if a project-related item is eligible for capitalization.|1086|WORK\_TYPE\_ID|NUMBER||18||Identifier for project-related classification of the worked performed.|1087|CONTRACT\_LINE\_ID|NUMBER||18||Tracks contract line information. Not used currently.|1088|FUNDING\_ALLOCATION\_ID|NUMBER||18||Specifies the name of the project funding override. Not used currently.|1089|RESERVED\_ATTRIBUTE1|VARCHAR2|150|||Reserved for funding source, external or internal, funding the sponsored project.|1090|RESERVED\_ATTRIBUTE2|VARCHAR2|150|||Reserved for future project-related functionality|1091|RESERVED\_ATTRIBUTE3|VARCHAR2|150|||Reserved for future project-related functionality|1092|RESERVED\_ATTRIBUTE4|VARCHAR2|150|||Reserved for future project-related functionality|1093|RESERVED\_ATTRIBUTE5|VARCHAR2|150|||Reserved for future project-related functionality|1094|RESERVED\_ATTRIBUTE6|VARCHAR2|150|||Reserved for future project-related functionality|1095|RESERVED\_ATTRIBUTE7|VARCHAR2|150|||Reserved for future project-related functionality|1096|RESERVED\_ATTRIBUTE8|VARCHAR2|150|||Reserved for future project-related functionality|1097|RESERVED\_ATTRIBUTE9|VARCHAR2|150|||Reserved for future project-related functionality|1098|RESERVED\_ATTRIBUTE10|VARCHAR2|150|||Reserved for future project-related functionality|1099|USER\_DEF\_ATTRIBUTE1|VARCHAR2|150|||Reserved for user-definable project information|1100|USER\_DEF\_ATTRIBUTE2|VARCHAR2|150|||Reserved for user-definable project information|1101|USER\_DEF\_ATTRIBUTE3|VARCHAR2|150|||Reserved for user-definable project information|1102|USER\_DEF\_ATTRIBUTE4|VARCHAR2|150|||Reserved for user-definable project information|1103|USER\_DEF\_ATTRIBUTE5|VARCHAR2|150|||Reserved for user-definable project information|1104|USER\_DEF\_ATTRIBUTE6|VARCHAR2|150|||Reserved for user-definable project information|1105|USER\_DEF\_ATTRIBUTE7|VARCHAR2|150|||Reserved for user-definable project information|1106|USER\_DEF\_ATTRIBUTE8|VARCHAR2|150|||Reserved for user-definable project information|1107|USER\_DEF\_ATTRIBUTE9|VARCHAR2|150|||Reserved for user-definable project information|1108|USER\_DEF\_ATTRIBUTE10|VARCHAR2|150|||Reserved for user-definable project information|1109|TIMECARD\_DIST\_FLAG|VARCHAR2|1|||Indicates that this is a time card based distribution.|1110 1111Foreign Keys1112 1113|**Table**|**Foreign Table**|**Foreign Key Column**|1114| :- | :- | :- |1115|PJC\_ALLOC\_TXN\_DETAILS|pjc\_alloc\_runs\_all|RUN\_ID|1116|PJC\_ALLOC\_TXN\_DETAILS|pjf\_projects\_all\_b|PROJECT\_ID|1117|PJC\_ALLOC\_TXN\_DETAILS|pjc\_exp\_items\_all|EXPENDITURE\_ITEM\_ID|1118|PJC\_ALLOC\_TXN\_DETAILS|pjf\_proj\_elements\_b|TASK\_ID|1119|PJC\_ALLOC\_TXN\_DETAILS|pjf\_proj\_elements\_b|CINT\_SOURCE\_TASK\_ID|1120|PJC\_ALLOC\_TXN\_DETAILS|pjc\_cint\_rs\_revisions|IND\_RATE\_SCH\_REVISION\_ID|1121|pjc\_labor\_dist\_txn\_details|pjc\_alloc\_txn\_details|ALLOC\_TXN\_ID|1122|pjc\_cint\_source\_details|pjc\_alloc\_txn\_details|ALLOC\_TXN\_ID|1123 1124Indexes1125 1126|**Index**|**Uniqueness**|**Tablespace**|**Columns**|1127| :- | :- | :- | :- |1128|PJC\_ALLOC\_TXN\_DETAILS\_N1|Non Unique|Default|RUN\_ID, TRANSACTION\_TYPE, PROJECT\_ID, TASK\_ID|1129|PJC\_ALLOC\_TXN\_DETAILS\_N2|Non Unique|Default|PROJECT\_ID|1130|PJC\_ALLOC\_TXN\_DETAILS\_N3|Non Unique|Default|TASK\_ID|1131|PJC\_ALLOC\_TXN\_DETAILS\_N4|Non Unique|Default|RUN\_TARGET\_ID|1132|PJC\_ALLOC\_TXN\_DETAILS\_U1|Unique|Default|ALLOC\_TXN\_ID|1133 1134PJC\_ASSET\_ASSIGN\_INT1135 1136PJC\_ASSET\_ASSIGN\_INT is the table you use to import information for the asset assignment uploaded using FBDI.1137 1138Details1139 1140- Schema: FUSION1141- Object owner: PJC1142- Object type: TABLE1143- Tablespace: INTERFACE1144 1145Columns1146 1147|**Name**|**Datatype**|**Length**|**Precision**|**Not-null**|**Comments**|1148| :- | :- | :- | :- | :- | :- |1149|ASSET\_ASGN\_INTERFACE\_ID|NUMBER||18|Yes|The system-generated number that uniquely identifies the asset assignment auto generated.|1150|ASSET\_ASSIGNMENT\_ID|NUMBER||18||The system-generated number that uniquely identifies the asset assignment.|1151|PROJECT\_ASSET\_ID|NUMBER||18||The identifier of the asset; value is 0 for common cost assignments.|1152|BATCH\_NAME|VARCHAR2|50|||User-entered name for a grouping of asset assigments in the interface table.|1153|ASSET\_NAME|VARCHAR2|240|||Asset Name that uniquely identifies an asset within a project.|1154|ASSET\_NUMBER|VARCHAR2|30|||Unique asset identifier that is either user-entered or system-generated.|1155|STATUS\_CODE|VARCHAR2|1||Yes|Default 'P'. Processing status. P- Pending, S-Success,R-Rejected, T-Transferred.|1156|PROCESSING\_MODE|VARCHAR2|10||Yes|Processing Mode-Create/Update/Delete.|1157|ASSET\_ASSIGNMENT\_LEVEL|VARCHAR2|40|||(1)Project Level Assignment (2) Task Level Assignment (3) Common Cost Assignment at Project Level (4) Common Cost Assignment at Task Level.|1158|PROJECT\_ID|NUMBER||18||The identifier of the project involved in the assignment.|1159|PROJECT\_NAME|VARCHAR2|240|||The name of the project to which the asset belongs.|1160|PROJECT\_NUMBER|VARCHAR2|25|||The number of the project to which the asset belongs.|1161|TASK\_ID|NUMBER||18||The identifier of the task; value is 0 on project-level assignments.|1162|TASK\_NAME|VARCHAR2|255|||The name of the task to which the asset belongs.|1163|TASK\_NUMBER|VARCHAR2|100|||The number of the task to which the asset belongs.|1164|ATTRIBUTE\_CATEGORY|VARCHAR2|30|||Descriptive Flexfield: structure definition of the user descriptive flexfield.|1165|ATTRIBUTE1|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1166|ATTRIBUTE2|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1167|ATTRIBUTE3|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1168|ATTRIBUTE4|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1169|ATTRIBUTE5|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1170|ATTRIBUTE6|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1171|ATTRIBUTE7|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1172|ATTRIBUTE8|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1173|ATTRIBUTE9|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1174|ATTRIBUTE10|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1175|ATTRIBUTE11|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1176|ATTRIBUTE12|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1177|ATTRIBUTE13|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1178|ATTRIBUTE14|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1179|ATTRIBUTE15|VARCHAR2|150|||Descriptive Flexfield: segment of the user descriptive flexfield.|1180|REQUEST\_ID|NUMBER||18||Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.|1181|PREV\_REQUEST\_ID|NUMBER||18||Enterprise Service Scheduler: indicates the previous request ID of the job that processed this record.|1182|LOAD\_REQUEST\_ID|NUMBER||18|Yes|Enterprise Service Scheduler: indicates the request ID of the job that loaded this record.|1183|PROCESS\_GROUP\_ID|NUMBER||18||Identifier on each record to group a batch of records for parallel processing.|1184|CREATION\_DATE|TIMESTAMP||||Who column: indicates the date and time of the creation of the row.|1185|CREATED\_BY|VARCHAR2|64|||Who column: indicates the user who created the row.|1186|LAST\_UPDATE\_DATE|TIMESTAMP||||Who column: indicates the date and time of the last update of the row.|1187|LAST\_UPDATED\_BY|VARCHAR2|64|||Who column: indicates the user who last updated the row.|1188|LAST\_UPDATE\_LOGIN|VARCHAR2|32|||Who column: indicates the session login associated to the user who last updated the row.|1189 1190Indexes1191 1192|**Index**|**Uniqueness**|**Tablespace**|**Columns**|1193| :- | :- | :- | :- |1194|PJC\_ASSET\_ASSIGN\_INT\_N1|Non Unique|Default|BATCH\_NAME|1195|PJC\_ASSET\_ASSIGN\_INT\_N2|Non Unique|Default|PROJECT\_NUMBER|1196|PJC\_ASSET\_ASSIGN\_INT\_N3|Non Unique|Default|PROCESS\_GROUP\_ID, STATUS\_CODE|1197|PJC\_ASSET\_ASSIGN\_INT\_N4|Non Unique|Default|REQUEST\_ID, PROJECT\_ID, TASK\_ID|1198|PJC\_ASSET\_ASSIGN\_INT\_N5|Non Unique|Default|PROJECT\_ASSET\_ID|1199|PJC\_ASSET\_ASSIGN\_INT\_U1|Unique|Default|ASSET\_ASGN\_INTERFACE\_ID|1200 

Showing the first 1,200 of 7370 lines. Download the file for the rest.