HP_POS_RTBC_WRK(SQL Table) |
Index Back |
|---|---|
RTBC Position Temp TableRTBC Position Temp Table is used for RTBC for online pre-encumbrance calculations |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | POSN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Position Status
A=Approved P=Proposed R=Frozen |
| 5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 9 | FULL_PART_TIME | Character(1) | VARCHAR2(1) NOT NULL |
Full/Part Time
D=On Demand F=Full-Time P=Part-Time |
| 10 | SAL_ADMIN_PLAN | Character(4) | VARCHAR2(4) NOT NULL | Salary Administration Plan |
| 11 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |
| 12 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 13 | FTE | Number(8,6) | DECIMAL(7,6) NOT NULL | This field represent Full Time Equivalence |
| 14 | MAX_HEAD_COUNT | Number(4,0) | SMALLINT NOT NULL | Max Head Count |
| 15 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 16 | ENCUMBER_INDC | Character(1) | VARCHAR2(1) NOT NULL |
Encumbrance Indicator
I=Encumber Immediately N=No Encumbrance R=Encumber on Requisition |
| 17 | ENCUMB_SAL_OPTN | Character(3) | VARCHAR2(3) NOT NULL |
Encumber Salary Option
COM=Sum of Default Components MAX=Salary Grade Maximum MID=Salary Grade Midpoint MIN=Salary Grade Minimum STP=Salary Step USR=User Specified Amount |
| 18 | ENCUMB_SAL_AMT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Encumber Salary Amount |