HP_JOB_RTBC_WRK (SQL Table)	Index Back
RTBC Job Temp Table RTBC Job Temp Table is used for RTBC for online encumbrance calculations

HP_JOB_RTBC_WRK

(SQL Table)

RTBC Job Temp Table

RTBC Job Temp Table is used for RTBC for online encumbrance calculations

Parent record: JOB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: JOB.EFFDT

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

7 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

8 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

9 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

11 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

13 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

14 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

15 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours

16 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

17 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

18 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

19 STEP Number(2,0) SMALLINT NOT NULL Step

20 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence

21 SHIFT Character(1) VARCHAR2(1) NOT NULL Regular Shift
1=Day
2=Evening
3=Night
A=Any
C=Compressed
N=Not Applicable
R=Rotating

22 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

23 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

24 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

25 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried

26 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

27 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary

28 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

29 EARNS_DIST_TYPE Character(1) VARCHAR2(1) NOT NULL Earnings Distribution Type
A=By Amount
H=By Hours
N=None
P=By Percent

30 ENCUMB_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Encumbrance Override

31 POSITION_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Position Data

32 ACTION Character(3) VARCHAR2(3) NOT NULL Action

33 ACTION_DT Date(10) DATE Action Date

34 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

35 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: JOB.EFFDT
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
7	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
8	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
9	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
10	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
11	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
12	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
13	COMP_FREQUENCY	Character(5)	VARCHAR2(5) NOT NULL	Compensation Frequency A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly
14	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
15	STD_HOURS	Number(7,2)	DECIMAL(6,2) NOT NULL	Standard Hours
16	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID
17	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
18	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
19	STEP	Number(2,0)	SMALLINT NOT NULL	Step
20	FTE	Number(8,6)	DECIMAL(7,6) NOT NULL	This field represent Full Time Equivalence
21	SHIFT	Character(1)	VARCHAR2(1) NOT NULL	Regular Shift 1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating
22	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
23	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
24	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
25	EMPL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Employee Type E=Exception Hourly H=Hourly N=Not Applicable S=Salaried
26	EMPL_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Employee Classification
27	REG_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Regular/Temporary R=Regular T=Temporary
28	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
29	EARNS_DIST_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Earnings Distribution Type A=By Amount H=By Hours N=None P=By Percent
30	ENCUMB_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Encumbrance Override
31	POSITION_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Override Position Data
32	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
33	ACTION_DT	Date(10)	DATE	Action Date
34	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
35	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.