XCC_CONTROL_BUDGETS_PRIVATE_GT
This temporary table contains data that is used to perform validations and derivations before entering them into real functional tables.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| NAME | VARCHAR2 | 100 | Yes | Unique identifier of the control budget. | |
| DESCRIPTION | VARCHAR2 | 240 | Description of the control budget. | ||
| START_PERIOD_NAME | VARCHAR2 | 15 | Period when the control budget starts being effective. | ||
| START_DATE | DATE | Date when the control budget starts being effective. | |||
| START_EFF_PERIOD_NUM | NUMBER | 18 | Effective period number of the start period of the control budget. | ||
| END_PERIOD_NAME | VARCHAR2 | 15 | End period of the control budget. | ||
| END_DATE | DATE | Date when the control budget stops being effective. | |||
| END_EFF_PERIOD_NUM | NUMBER | 18 | Effective period number of the end period of the control budget. | ||
| CALENDAR_ID | NUMBER | 18 | Calendar identifier used for the control budget. | ||
| PERIOD_SET_NAME | VARCHAR2 | 15 | Period set name of the budget calendar. | ||
| PERIOD_TYPE | VARCHAR2 | 15 | Period type of the control budget calendar. | ||
| CONTROL_LEVEL_CODE | VARCHAR2 | 30 | Control level code to determine funds available. | ||
| TOLERANCE_AMOUNT | NUMBER | Fixed amount used as tolerance. | |||
| TOLERANCE_PERCENT | NUMBER | Percentage of the budget amount that is used as tolerance. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency assigned to the control budget. | ||
| UOM_CODE | VARCHAR2 | 3 | Unit of measure assigned to the control budget. | ||
| DEFAULT_RATE_TYPE | VARCHAR2 | 30 | Default rate type assigned to the control budget. | ||
| LEDGER_ID | NUMBER | 18 | Primary ledger identifier defined in the GL and enabled for budgetary control. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Unique identifier of the key flexfield structure that is used to define columns for the associated ledger's chart of accounts. | ||
| PROJECT_ID | NUMBER | 18 | Unique identifier of the accounting project. The default value is -98. | ||
| BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Unique identifier of the key flexfield structure that is used to define columns for control budget accounts. | ||
| BUDGET_MANAGER_ID | NUMBER | 18 | Unique identifier of the budget manager responsible for the control budget. | ||
| BALANCE_INCREASES_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether increases are allowed as adjustments to the initial loaded amounts for the budget account combination of the control budget. The default value is Y. | ||
| BALANCE_DECREASES_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether decreases are allowed as adjustments to the initial loaded amounts for the budget account combination of the control budget. The default value is Y. | ||
| NEGATIVE_BALANCES_ALLOWED_FLAG | VARCHAR2 | 1 | Indicates whether the funds available balance can assume a negative value when adjusted to the initial loaded amounts for budget account combination of the control budget. The default value is N. | ||
| PJC_CONTRACT_ID | NUMBER | 18 | Unique project accounting contract identifier for the award associated with the budget amount. The default value is -98. | ||
| INTERNAL_BUDGET_TYPE_CODE | VARCHAR2 | 30 | Order of segments in the budget chart of accounts structure for project based control budgets. For example, PARF indicates a segment order of Project, Award, Top Resource, and Funding Source. | ||
| MASTER_CONTROL_BUDGET_NAME | VARCHAR2 | 100 | Detail control budget name of the summary control budget. | ||
| STATUS_CODE | VARCHAR2 | 30 | The processing status of the control budget. | ||
| IMPORT_DATA_SET_ID | NUMBER | 18 | Yes | Unique identifier to call the control budget import process. | |
| CONTROL_BUDGET_ID | NUMBER | 18 | Unique identifier of the control budget. | ||
| BUDGET_SEGMENT1 | VARCHAR2 | 30 | First budget segment of the control budget. | ||
| BUDGET_SEGMENT2 | VARCHAR2 | 30 | Second budget segment of the control budget. | ||
| BUDGET_SEGMENT3 | VARCHAR2 | 30 | Third budget segment of the control budget. | ||
| BUDGET_SEGMENT4 | VARCHAR2 | 30 | Fourth budget segment of the control budget. | ||
| BUDGET_SEGMENT5 | VARCHAR2 | 30 | Fifth budget segment of the control budget. | ||
| BUDGET_SEGMENT6 | VARCHAR2 | 30 | Sixth budget segment of the control budget. | ||
| BUDGET_SEGMENT7 | VARCHAR2 | 30 | Seventh budget segment of the control budget. | ||
| BUDGET_SEGMENT8 | VARCHAR2 | 30 | Eighth budget segment of the control budget. | ||
| BUDGET_SEGMENT9 | VARCHAR2 | 30 | Ninth budget segment of the control budget. | ||
| BUDGET_SEGMENT10 | VARCHAR2 | 30 | Tenth budget segment of the control budget. | ||
| BUDGET_SEGMENT11 | VARCHAR2 | 30 | Eleventh budget segment of the control budget. | ||
| BUDGET_SEGMENT12 | VARCHAR2 | 30 | Twelfth budget segment of the control budget. | ||
| BUDGET_SEGMENT13 | VARCHAR2 | 30 | Thirteenth budget segment of the control budget. | ||
| BUDGET_SEGMENT14 | VARCHAR2 | 30 | Fourteenth budget segment of the control budget. | ||
| BUDGET_SEGMENT15 | VARCHAR2 | 30 | Fifteenth budget segment of the control budget. | ||
| BUDGET_SEGMENT16 | VARCHAR2 | 30 | Sixteenth budget segment of the control budget. | ||
| BUDGET_SEGMENT17 | VARCHAR2 | 30 | Seventeenth budget segment of the control budget. | ||
| BUDGET_SEGMENT18 | VARCHAR2 | 30 | Eighteenth budget segment of the control budget. | ||
| BUDGET_SEGMENT19 | VARCHAR2 | 30 | Nineteenth budget segment of the control budget. | ||
| BUDGET_SEGMENT20 | VARCHAR2 | 30 | Twentieth budget segment of the control budget. | ||
| BUDGET_SEGMENT21 | VARCHAR2 | 30 | Twenty-first budget segment of the control budget. | ||
| BUDGET_SEGMENT22 | VARCHAR2 | 30 | Twenty-second budget segment of the control budget. | ||
| BUDGET_SEGMENT23 | VARCHAR2 | 30 | Twenty-third budget segment of the control budget. | ||
| BUDGET_SEGMENT24 | VARCHAR2 | 30 | Twenty-fourth budget segment of the control budget. | ||
| BUDGET_SEGMENT25 | VARCHAR2 | 30 | Twenty-fifth budget segment of the control budget. | ||
| BUDGET_SEGMENT26 | VARCHAR2 | 30 | Twenty-sixth budget segment of the control budget. | ||
| BUDGET_SEGMENT27 | VARCHAR2 | 30 | Twenty-seventh budget segment of the control budget. | ||
| BUDGET_SEGMENT28 | VARCHAR2 | 30 | Twenty-eighth budget segment of the control budget. | ||
| BUDGET_SEGMENT29 | VARCHAR2 | 30 | Twenty-ninth budget segment of the control budget. | ||
| BUDGET_SEGMENT30 | VARCHAR2 | 30 | Thirtieth budget segment of the control budget. | ||
| KEY_SEGMENT1_ID | NUMBER | 18 | Unique identifier of the first budget segment row. | ||
| KEY_SEGMENT2_ID | NUMBER | 18 | Unique identifier of the second budget segment row. | ||
| KEY_SEGMENT3_ID | NUMBER | 18 | Unique identifier of the third budget segment row. | ||
| KEY_SEGMENT4_ID | NUMBER | 18 | Unique identifier of the fourth budget segment row. | ||
| KEY_SEGMENT5_ID | NUMBER | 18 | Unique identifier of the fifth budget segment row. | ||
| KEY_SEGMENT6_ID | NUMBER | 18 | Unique identifier of the sixth budget segment row. | ||
| KEY_SEGMENT7_ID | NUMBER | 18 | Unique identifier of the seventh budget segment row. | ||
| KEY_SEGMENT8_ID | NUMBER | 18 | Unique identifier of the eighth budget segment row. | ||
| KEY_SEGMENT9_ID | NUMBER | 18 | Unique identifier of the ninth budget segment row. | ||
| KEY_SEGMENT10_ID | NUMBER | 18 | Unique identifier of the tenth budget segment row. | ||
| KEY_SEGMENT11_ID | NUMBER | 18 | Unique identifier of the eleventh budget segment row. | ||
| KEY_SEGMENT12_ID | NUMBER | 18 | Unique identifier for the twelfth budget segment row. | ||
| KEY_SEGMENT13_ID | NUMBER | 18 | Unique identifier for the thirteenth budget segment row. | ||
| KEY_SEGMENT14_ID | NUMBER | 18 | Unique identifier for the fourteenth budget segment row. | ||
| KEY_SEGMENT15_ID | NUMBER | 18 | Unique identifier for the fifteenth budget segment row. | ||
| KEY_SEGMENT16_ID | NUMBER | 18 | Unique identifier for the sixteenth budget segment row. | ||
| KEY_SEGMENT17_ID | NUMBER | 18 | Unique identifier for the seventeenth budget segment row. | ||
| KEY_SEGMENT18_ID | NUMBER | 18 | Unique identifier for the eighteenth budget segment row. | ||
| KEY_SEGMENT19_ID | NUMBER | 18 | Unique identifier for the nineteenth budget segment row. | ||
| KEY_SEGMENT20_ID | NUMBER | 18 | Unique identifier for the twentieth budget segment row. | ||
| KEY_SEGMENT21_ID | NUMBER | 18 | Unique identifier for the twenty-first budget segment row. | ||
| KEY_SEGMENT22_ID | NUMBER | 18 | Unique identifier for the twenty-second budget segment row. | ||
| KEY_SEGMENT23_ID | NUMBER | 18 | Unique identifier for the twenty-third budget segment row. | ||
| KEY_SEGMENT24_ID | NUMBER | 18 | Unique identifier for the twenty-fourth budget segment row. | ||
| KEY_SEGMENT25_ID | NUMBER | 18 | Unique identifier for the twenty-fifth budget segment row. | ||
| KEY_SEGMENT26_ID | NUMBER | 18 | Unique identifier for the twenty-sixth budget segment row. | ||
| KEY_SEGMENT27_ID | NUMBER | 18 | Unique identifier for the twenty-seventh budget segment row. | ||
| KEY_SEGMENT28_ID | NUMBER | 18 | Unique identifier for the twenty-eighth budget segment row. | ||
| KEY_SEGMENT29_ID | NUMBER | 18 | Unique identifier for the twenty-ninth budget segment row. | ||
| KEY_SEGMENT30_ID | NUMBER | 18 | Unique identifier for the thirtieth budget segment row. | ||
| PARENT_SOURCE_SYSTEM | VARCHAR2 | 30 | Source budget type code of the detail control budget. | ||
| PARENT_SOURCE_BUDGET | VARCHAR2 | 100 | Source budget name of the detail control budget. | ||
| SOURCE_BUDGET | VARCHAR2 | 100 | Source budget name of the control budget. | ||
| SOURCE_BUDGET_SYSTEM_CODE | VARCHAR2 | 30 | Source budget type code of the control budget. | ||
| FUNDS_RELEASE_TIMEFRAME | VARCHAR2 | 30 | Determines when the funds are made available for a particular period. Possible values are RELEASE_IMMEDIATELY and RELEASE_UPON_OPEN. | ||
| ALLOW_OVERRIDES_FLAG | VARCHAR2 | 1 | Indicates if overrides are allowed for this control budget. | ||
| NO_OVERRIDES_NOTIFY_FLAG | VARCHAR2 | 1 | Indicates if the budget manager must be notified when no overrides are available. | ||
| OVERRIDES_TAKEN_NOTIFY_FLAG | VARCHAR2 | 1 | Indicates if the budget manager must be notified when an override is taken. | ||
| MAXIMUM_OVERRIDE_AMOUNT | NUMBER | Maximum override amount allowed for this control budget. Amount is in the budget currency. | |||
| TREE_VERSION_ID1 | VARCHAR2 | 32 | Unique tree version identifier for the first segment. | ||
| TREE_VERSION_ID2 | VARCHAR2 | 32 | Unique tree version identifier for the second segment. | ||
| TREE_VERSION_ID3 | VARCHAR2 | 32 | Unique tree version identifier for the third segment. | ||
| TREE_VERSION_ID4 | VARCHAR2 | 32 | Unique tree version identifier for the fourth segment. | ||
| TREE_VERSION_ID5 | VARCHAR2 | 32 | Unique tree version identifier for the fifth segment. | ||
| TREE_VERSION_ID6 | VARCHAR2 | 32 | Unique tree version identifier for the sixth segment. | ||
| TREE_VERSION_ID7 | VARCHAR2 | 32 | Unique tree version identifier for the seventh segment. | ||
| TREE_VERSION_ID8 | VARCHAR2 | 32 | Unique tree version identifier for the eighth segment. | ||
| TREE_VERSION_ID9 | VARCHAR2 | 32 | Unique tree version identifier for the ninth segment. | ||
| TREE_VERSION_ID10 | VARCHAR2 | 32 | Unique tree version identifier for the tenth segment. | ||
| TREE_VERSION_ID11 | VARCHAR2 | 32 | Unique tree version identifier for the eleventh segment. | ||
| TREE_VERSION_ID12 | VARCHAR2 | 32 | Unique tree version identifier for the twelfth segment. | ||
| TREE_VERSION_ID13 | VARCHAR2 | 32 | Unique tree version identifier for the thirteenth segment. | ||
| TREE_VERSION_ID14 | VARCHAR2 | 32 | Unique tree version identifier for the fourteenth segment. | ||
| TREE_VERSION_ID15 | VARCHAR2 | 32 | Unique tree version identifier for the fifteenth segment. | ||
| TREE_VERSION_ID16 | VARCHAR2 | 32 | Unique tree version identifier for the sixteenth segment. | ||
| TREE_VERSION_ID17 | VARCHAR2 | 32 | Unique tree version identifier for the seventeenth segment. | ||
| TREE_VERSION_ID18 | VARCHAR2 | 32 | Unique tree version identifier for the eighteenth segment. | ||
| TREE_VERSION_ID19 | VARCHAR2 | 32 | Unique tree version identifier for the nineteenth segment. | ||
| TREE_VERSION_ID20 | VARCHAR2 | 32 | Unique tree version identifier for the twentieth segment. | ||
| TREE_VERSION_ID21 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-first segment. | ||
| TREE_VERSION_ID22 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-second segment. | ||
| TREE_VERSION_ID23 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-third segment. | ||
| TREE_VERSION_ID24 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-fourth segment. | ||
| TREE_VERSION_ID25 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-fifth segment. | ||
| TREE_VERSION_ID26 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-sixth segment. | ||
| TREE_VERSION_ID27 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-seventh segment. | ||
| TREE_VERSION_ID28 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-eighth segment. | ||
| TREE_VERSION_ID29 | VARCHAR2 | 32 | Unique tree version identifier for the twenty-ninth segment. | ||
| TREE_VERSION_ID30 | VARCHAR2 | 32 | Unique tree version identifier for the thirtieth segment. | ||
| OBJECT_ID | NUMBER | 18 | Yes | Unique object identifier for internal use by Project Portfolio Management and U.S. Federal Financials. | |
| FV_TYPE_CODE | VARCHAR2 | 30 | Indicates the budgetary control processing type code of the control budget. | ||
| SOURCE_SEGMENT_TYPE1 | VARCHAR2 | 30 | Indicates if the mapped segment of the control budget's first budget segment is one of these: COA segment, project element. | ||
| SOURCE_SEGMENT_TYPE2 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of second budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE3 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of third budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE4 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fourth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE5 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fifth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE6 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of sixth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE7 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of seventh budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE8 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of eighth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE9 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of ninth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE10 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of tenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE11 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of eleventh budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE12 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twelfth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE13 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of thirteenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE14 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fourteenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE15 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of fifteenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE16 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of sixteenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE17 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of seventeenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE18 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of eighteenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE19 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of nineteenth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE20 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twentieth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE21 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-first budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE22 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-second budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE23 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-third budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE24 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-fourth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE25 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-fifth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE26 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-sixth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE27 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-seventh budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE28 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-eighth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE29 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of twenty-ninth budget segment of the control budget. | ||
| SOURCE_SEGMENT_TYPE30 | VARCHAR2 | 30 | This indicates if the mapped segment is a COA segment or project DFF segment or project element of thirtieth budget segment of the control budget. | ||
| TREE_STRUCTURE_CODE1 | VARCHAR2 | 30 | Unique tree structure code identifier for the first segment. | ||
| TREE_STRUCTURE_CODE2 | VARCHAR2 | 30 | Unique tree structure code identifier for the second segment. | ||
| TREE_STRUCTURE_CODE3 | VARCHAR2 | 30 | Unique tree structure code identifier for the third segment. | ||
| TREE_STRUCTURE_CODE4 | VARCHAR2 | 30 | Unique tree structure code identifier for the fourth segment. | ||
| TREE_STRUCTURE_CODE5 | VARCHAR2 | 30 | Unique tree structure code identifier for the fifth segment. | ||
| TREE_STRUCTURE_CODE6 | VARCHAR2 | 30 | Unique tree structure code identifier for the sixth segment. | ||
| TREE_STRUCTURE_CODE7 | VARCHAR2 | 30 | Unique tree structure code identifier for the seventh segment. | ||
| TREE_STRUCTURE_CODE8 | VARCHAR2 | 30 | Unique tree structure code identifier for the eighth segment. | ||
| TREE_STRUCTURE_CODE9 | VARCHAR2 | 30 | Unique tree structure code identifier for the ninth segment. | ||
| TREE_STRUCTURE_CODE10 | VARCHAR2 | 30 | Unique tree structure code identifier for the tenth segment. | ||
| TREE_STRUCTURE_CODE11 | VARCHAR2 | 30 | Unique tree structure code identifier for the eleventh segment. | ||
| TREE_STRUCTURE_CODE12 | VARCHAR2 | 30 | Unique tree structure code identifier for the twelfth segment. | ||
| TREE_STRUCTURE_CODE13 | VARCHAR2 | 30 | Unique tree structure code identifier for the thirteenth segment. | ||
| TREE_STRUCTURE_CODE14 | VARCHAR2 | 30 | Unique tree structure code identifier for the fourteenth segment. | ||
| TREE_STRUCTURE_CODE15 | VARCHAR2 | 30 | Unique tree structure code identifier for the fifteenth segment. | ||
| TREE_STRUCTURE_CODE16 | VARCHAR2 | 30 | Unique tree structure code identifier for the sixteenth segment. | ||
| TREE_STRUCTURE_CODE17 | VARCHAR2 | 30 | Unique tree structure code identifier for the seventeenth segment. | ||
| TREE_STRUCTURE_CODE18 | VARCHAR2 | 30 | Unique tree structure code identifier for the eighteenth segment. | ||
| TREE_STRUCTURE_CODE19 | VARCHAR2 | 30 | Unique tree structure code identifier for the nineteenth segment. | ||
| TREE_STRUCTURE_CODE20 | VARCHAR2 | 30 | Unique tree structure code identifier for the twentieth segment. | ||
| TREE_STRUCTURE_CODE21 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-first segment. | ||
| TREE_STRUCTURE_CODE22 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-second segment. | ||
| TREE_STRUCTURE_CODE23 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-third segment. | ||
| TREE_STRUCTURE_CODE24 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-fourth segment. | ||
| TREE_STRUCTURE_CODE25 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-fifth segment. | ||
| TREE_STRUCTURE_CODE26 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-sixth segment. | ||
| TREE_STRUCTURE_CODE27 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-seventh segment. | ||
| TREE_STRUCTURE_CODE28 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-eighth segment. | ||
| TREE_STRUCTURE_CODE29 | VARCHAR2 | 30 | Unique tree structure code identifier for the twenty-ninth segment. | ||
| TREE_STRUCTURE_CODE30 | VARCHAR2 | 30 | Unique tree structure code identifier for the thirtieth segment. | ||
| TREE_CODE1 | VARCHAR2 | 30 | Unique tree code identifier for the first segment. | ||
| TREE_CODE2 | VARCHAR2 | 30 | Unique tree code identifier for the second segment. | ||
| TREE_CODE3 | VARCHAR2 | 30 | Unique tree code identifier for the third segment. | ||
| TREE_CODE4 | VARCHAR2 | 30 | Unique tree code identifier for the fourth segment. | ||
| TREE_CODE5 | VARCHAR2 | 30 | Unique tree code identifier for the fifth segment. | ||
| TREE_CODE6 | VARCHAR2 | 30 | Unique tree code identifier for the sixth segment. | ||
| TREE_CODE7 | VARCHAR2 | 30 | Unique tree code identifier for the seventh segment. | ||
| TREE_CODE8 | VARCHAR2 | 30 | Unique tree code identifier for the eighth segment. | ||
| TREE_CODE9 | VARCHAR2 | 30 | Unique tree code identifier for the ninth segment. | ||
| TREE_CODE10 | VARCHAR2 | 30 | Unique tree code identifier for the tenth segment. | ||
| TREE_CODE11 | VARCHAR2 | 30 | Unique tree code identifier for the eleventh segment. | ||
| TREE_CODE12 | VARCHAR2 | 30 | Unique tree code identifier for the twelfth segment. | ||
| TREE_CODE13 | VARCHAR2 | 30 | Unique tree code identifier for the thirteenth segment. | ||
| TREE_CODE14 | VARCHAR2 | 30 | Unique tree code identifier for the fourteenth segment. | ||
| TREE_CODE15 | VARCHAR2 | 30 | Unique tree code identifier for the fifteenth segment. | ||
| TREE_CODE16 | VARCHAR2 | 30 | Unique tree code identifier for the sixteenth segment. | ||
| TREE_CODE17 | VARCHAR2 | 30 | Unique tree code identifier for the seventeenth segment. | ||
| TREE_CODE18 | VARCHAR2 | 30 | Unique tree code identifier for the eighteenth segment. | ||
| TREE_CODE19 | VARCHAR2 | 30 | Unique tree code identifier for the nineteenth segment. | ||
| TREE_CODE20 | VARCHAR2 | 30 | Unique tree code identifier for the twentieth segment. | ||
| TREE_CODE21 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-first segment. | ||
| TREE_CODE22 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-second segment. | ||
| TREE_CODE23 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-third segment. | ||
| TREE_CODE24 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-fourth segment. | ||
| TREE_CODE25 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-fifth segment. | ||
| TREE_CODE26 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-sixth segment. | ||
| TREE_CODE27 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-seventh segment. | ||
| TREE_CODE28 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-eighth segment. | ||
| TREE_CODE29 | VARCHAR2 | 30 | Unique tree code identifier for the twenty-ninth segment. | ||
| TREE_CODE30 | VARCHAR2 | 30 | Unique tree code identifier for the thirtieth segment. | ||
| TREE_LABEL_ID1 | VARCHAR2 | 32 | Unique tree label identifier for the first segment. | ||
| TREE_LABEL_ID2 | VARCHAR2 | 32 | Unique tree label identifier for the second segment. | ||
| TREE_LABEL_ID3 | VARCHAR2 | 32 | Unique tree label identifier for the third segment. | ||
| TREE_LABEL_ID4 | VARCHAR2 | 32 | Unique tree label identifier for the fourth segment. | ||
| TREE_LABEL_ID5 | VARCHAR2 | 32 | Unique tree label identifier for the fifth segment. | ||
| TREE_LABEL_ID6 | VARCHAR2 | 32 | Unique tree label identifier for the sixth segment. | ||
| TREE_LABEL_ID7 | VARCHAR2 | 32 | Unique tree label identifier for the seventh segment. | ||
| TREE_LABEL_ID8 | VARCHAR2 | 32 | Unique tree label identifier for the eighth segment. | ||
| TREE_LABEL_ID9 | VARCHAR2 | 32 | Unique tree label identifier for the ninth segment. | ||
| TREE_LABEL_ID10 | VARCHAR2 | 32 | Unique tree label identifier for the tenth segment. | ||
| TREE_LABEL_ID11 | VARCHAR2 | 32 | Unique tree label identifier for the eleventh segment. | ||
| TREE_LABEL_ID12 | VARCHAR2 | 32 | Unique tree label identifier for the twelfth segment. | ||
| TREE_LABEL_ID13 | VARCHAR2 | 32 | Unique tree label identifier for the thirteenth segment. | ||
| TREE_LABEL_ID14 | VARCHAR2 | 32 | Unique tree label identifier for the fourteenth segment. | ||
| TREE_LABEL_ID15 | VARCHAR2 | 32 | Unique tree label identifier for the fifteenth segment. | ||
| TREE_LABEL_ID16 | VARCHAR2 | 32 | Unique tree label identifier for the sixteenth segment. | ||
| TREE_LABEL_ID17 | VARCHAR2 | 32 | Unique tree label identifier for the seventeenth segment. | ||
| TREE_LABEL_ID18 | VARCHAR2 | 32 | Unique tree label identifier for the eighteenth segment. | ||
| TREE_LABEL_ID19 | VARCHAR2 | 32 | Unique tree label identifier for the nineteenth segment. | ||
| TREE_LABEL_ID20 | VARCHAR2 | 32 | Unique tree label identifier for the twentieth segment. | ||
| TREE_LABEL_ID21 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-first segment. | ||
| TREE_LABEL_ID22 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-second segment. | ||
| TREE_LABEL_ID23 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-third segment. | ||
| TREE_LABEL_ID24 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-fourth segment. | ||
| TREE_LABEL_ID25 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-fifth segment. | ||
| TREE_LABEL_ID26 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-sixth segment. | ||
| TREE_LABEL_ID27 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-seventh segment. | ||
| TREE_LABEL_ID28 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-eighth segment. | ||
| TREE_LABEL_ID29 | VARCHAR2 | 32 | Unique tree label identifier for the twenty-ninth segment. | ||
| TREE_LABEL_ID30 | VARCHAR2 | 32 | Unique tree label identifier for the thirtieth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID1 | VARCHAR2 | 32 | Unique tree label data source identifier for the first segment. | ||
| TREE_LABEL_DATA_SOURCE_ID2 | VARCHAR2 | 32 | Unique tree label data source identifier for the second segment. | ||
| TREE_LABEL_DATA_SOURCE_ID3 | VARCHAR2 | 32 | Unique tree label data source identifier for the third segment. | ||
| TREE_LABEL_DATA_SOURCE_ID4 | VARCHAR2 | 32 | Unique tree label data source identifier for the fourth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID5 | VARCHAR2 | 32 | Unique tree label data source identifier for the fifth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID6 | VARCHAR2 | 32 | Unique tree label data source identifier for the sixth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID7 | VARCHAR2 | 32 | Unique tree label data source identifier for the seventh segment. | ||
| TREE_LABEL_DATA_SOURCE_ID8 | VARCHAR2 | 32 | Unique tree label data source identifier for the eighth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID9 | VARCHAR2 | 32 | Unique tree label data source identifier for the ninth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID10 | VARCHAR2 | 32 | Unique tree label data source identifier for the tenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID11 | VARCHAR2 | 32 | Unique tree label data source identifier for the eleventh segment. | ||
| TREE_LABEL_DATA_SOURCE_ID12 | VARCHAR2 | 32 | Unique tree label data source identifier for the twelfth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID13 | VARCHAR2 | 32 | Unique tree label data source identifier for the thirteenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID14 | VARCHAR2 | 32 | Unique tree label data source identifier for the fourteenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID15 | VARCHAR2 | 32 | Unique tree label data source identifier for the fifteenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID16 | VARCHAR2 | 32 | Unique tree label data source identifier for the sixteenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID17 | VARCHAR2 | 32 | Unique tree label data source identifier for the seventeenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID18 | VARCHAR2 | 32 | Unique tree label data source identifier for the eighteenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID19 | VARCHAR2 | 32 | Unique tree label data source identifier for the nineteenth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID20 | VARCHAR2 | 32 | Unique tree label data source identifier for the twentieth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID21 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-first segment. | ||
| TREE_LABEL_DATA_SOURCE_ID22 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-second segment. | ||
| TREE_LABEL_DATA_SOURCE_ID23 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-third segment. | ||
| TREE_LABEL_DATA_SOURCE_ID24 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-fourth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID25 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-fifth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID26 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-sixth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID27 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-seventh segment. | ||
| TREE_LABEL_DATA_SOURCE_ID28 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-eighth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID29 | VARCHAR2 | 32 | Unique tree label data source identifier for the twenty-ninth segment. | ||
| TREE_LABEL_DATA_SOURCE_ID30 | VARCHAR2 | 32 | Unique tree label data source identifier for the thirtieth segment. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_CONTROL_BUDGETS_PVT_GT_N1 | Non Unique | SOURCE_BUDGET_SYSTEM_CODE |
| XCC_CONTROL_BUDGETS_PVT_GT_U1 | Unique | NAME |