BUSINESS_UNITPOSITION_NBRDefault Value: 0
A=Approved
P=Proposed
R=Frozen
Default Value: 1
Y/N Table Edit
Default Value: N
A=Add Record
C=Change Record
D=Delete Record
BD_POSITION_TBL(SQL Table) |
Index Back |
|---|---|
Budgets Position TableHRMS Position information f |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen |
| 5 | HEADCOUNT | Number(6,0) | INTEGER NOT NULL |
Headcount
Default Value: 1 |
| 6 | BUSINESS_UNIT_HR | Character(5) | VARCHAR2(5) NOT NULL | Business Unit for HRMS |
| 7 | POSITION_NBR_HR | Character(8) | VARCHAR2(8) NOT NULL | Position Number - HR |
| 8 | SPREADTYPE | Number(2,0) | SMALLINT NOT NULL | Public Sector Financials Budgets Work Field |
| 9 | SPREAD_TEMPLATE | Character(30) | VARCHAR2(30) NOT NULL | Spread Template Name |
| 10 | EXISTING_POSN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Public Sector Financials Budget Work Field
Y/N Table Edit Default Value: N |
| 11 | BD_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Public Sector Financials Budget Work Field
A=Add Record C=Change Record D=Delete Record |