BD_DISTR_TBL(SQL Table) |
Index Back |
|---|---|
Budgets Position Distrib TblHRMS distribution informatio |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Default Value: 0 |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: 0 |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL |
Effective Sequence
Default Value: 0 |
| 7 | COMPENSATION_IND |
Character(1) | VARCHAR2(1) NOT NULL |
Compensation Indicator
B=Benefits S=Salary |
| 8 | BD_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL |
Budget Sequence Number
Default Value: 0 |
| 9 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 10 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 11 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit |
| 12 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 13 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product |
| 14 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 15 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
| 16 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Public Sector Financials Chart Field |
| 17 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 18 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Resource Type |
| 19 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 20 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code |
| 21 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Public Sector Financials Chart Field. |
| 22 | BUDGET_PERIOD | Character(10) | VARCHAR2(10) NOT NULL | Budget Period |
| 23 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference Chartfield |
| 24 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield number 1 |
| 25 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 26 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 27 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 28 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 29 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL |
FTE Percentage
Default Value: 100 |
| 30 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 31 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 32 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 33 | BD_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Public Sector Financials Budget Work Field
A=Add Record C=Change Record D=Delete Record |