Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACTIVITY_DATE
|
Date record was inserted or updated
|
DATE
|
NA
|
SYSDATE
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
BUDGET
|
System defined code for the position's budget identification number.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_OBUD_CODE
|
BUDGET_PHASE
|
User-defined unique identifier of a budget phase identifier.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_OBPH_CODE
|
CHART_OF_ACCOUNTS1
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS10
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS2
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS3
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS4
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS5
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS6
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS7
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS8
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
CHART_OF_ACCOUNTS9
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_COAS_CODE
|
DISTRIBUTION_BUDGET1
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET10
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET2
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET3
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET4
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET5
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET6
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET7
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET8
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
DISTRIBUTION_BUDGET9
|
Amount of position total budget charged to this accounting distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_BUDGET
|
EXTERNAL_ACCOUNT1
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT10
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT2
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT3
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT4
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT5
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT6
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT7
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT8
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
EXTERNAL_ACCOUNT9
|
System account distribution code to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE_EXTERNAL
|
FISCAL_YEAR
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(4)
|
NBRPLBD
|
NBRPLBD_FISC_CODE
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
PERCENTAGE1
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE10
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE2
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE3
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE4
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE5
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE6
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE7
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE8
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
PERCENTAGE9
|
Percent of positions budget to be applied to this labor distribution.
|
NUMBER
|
NBRPLBD
|
NBRPLBD_PERCENT
|
POSITION
|
Position number.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_POSN
|
POSITION_ACCOUNT1
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT10
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT2
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT3
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT4
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT5
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT6
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT7
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT8
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT9
|
System defined code which The position account to be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCT_CODE
|
POSITION_ACCOUNT_INDEX1
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX10
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX2
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX3
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX4
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX5
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX6
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX7
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX8
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACCOUNT_INDEX9
|
An index code that is used to default the account distribution to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACCI_CODE
|
POSITION_ACTIVITY1
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY10
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY2
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY3
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY4
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY5
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY6
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY7
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY8
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_ACTIVITY9
|
System defined code that defines the activity to which the position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ACTV_CODE
|
POSITION_FUND1
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND10
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND2
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND3
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND4
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND5
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND6
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND7
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND8
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_FUND9
|
System defined code that identifies the fund to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_FUND_CODE
|
POSITION_LOCATION1
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION10
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION2
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION3
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION4
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION5
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION6
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION7
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION8
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_LOCATION9
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_LOCN_CODE
|
POSITION_ORGANIZATION1
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION10
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION2
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION3
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION4
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION5
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION6
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION7
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION8
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_ORGANIZATION9
|
System defined code that identifies the organization to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_ORGN_CODE
|
POSITION_PROGRAM1
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM10
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM2
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM3
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM4
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM5
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM6
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM7
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM8
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
POSITION_PROGRAM9
|
System defined code that identifies the program to which this position should be charged.
|
VARCHAR2(63)
|
NBRPLBD
|
NBRPLBD_PROG_CODE
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|