| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 2 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 3 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 4 |
HP_BUDGET_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Budget Year for Commitment Control
|
| 5 |
ENCUMB_PROC_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicate the encumbrance type on Budget Actuals and Encumbrance Distribution record.
ED=Encumber Deduction
EE=Encumber Salary
ET=Encumber Tax
PD=Postiion PreEncumber Deduction
PE=Position PreEncumber Salary
PT=Position PreEncumber Tax
RD=Job Req PreEncumber Deduction
RE=Job Req PreEncumber Salary
RT=Job Req PreEncumber Tax
|
| 6 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 7 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 8 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_CA_VW
|
| 9 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCOUNT_TBL
|
| 10 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 11 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
Prompt Table:
PER_ORG_ASGN_VW
|
| 12 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 13 |
HRS_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
Prompt Table:
HRS_JOB_OPENING
|
| 14 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
Prompt Table:
POOL_TBL
|
| 15 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
Prompt Table:
SET_JOB_DEP_VW
|
| 16 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 17 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 18 |
HP_KK_DOC_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Commitment Control Document ID
|
| 19 |
HP_KK_DOC_LINE_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Commitment Control Document Line #
|
| 20 |
POSTED_ACTUAL_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Posted Actual Amount
|
| 21 |
POSTED_NE_ACT_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Posted not Encumbered Actual Amount
|
| 22 |
POSTED_ENCUMB_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Posted Encumbrance Amount
|
| 23 |
ANNUAL_ENCUMB_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Annual Encumbered Amount
|
| 24 |
WORK_ACTUAL_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Work Actual Amount
|
| 25 |
WORK_ENCUMB_AMT |
Signed Number(18,2) |
DECIMAL(16,2) NOT NULL |
Work Encumbrance Amount
|
| 26 |
HP_ENC_DATE |
Date(10) |
DATE |
Encumbrance Date
|
| 27 |
HP_UPD_IN_PROGRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is to indicate if update is in progress for a particular Doc ID. If it is "Yes", then the Doc ID is locked until the update is completed.
|
| 28 |
HP_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 29 |
HP_EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 30 |
HP_POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 31 |
HP_JOB_OPENING_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Job Opening Clone
|
| 32 |
HP_ENC_START_DT |
Date(10) |
DATE |
Encumbrance Calculation Start Date. For current fiscal year, this is last pay confirm date + 1 day.
|