HP_DOC_ID_XREF(SQL Table) |
Index Back |
|---|---|
Doc ID XrefDoc ID Cross Reference file. This table is use to map between Doc ID and Doc Line number with Company, Paygroup, SetID, DeptID, Combo Code and Account. For Position or Job Requisition pre-encumbrance, it will be an one-to-one map between Doc ID with Position # and Job Opening ID. Each Combo Code (Account Code) will create a separate Doc Line number. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HP_KK_DOC_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Commitment Control Document ID |
| 2 | HP_KK_DOC_LINE_NBR |
Number(3,0) | SMALLINT NOT NULL | Commitment Control Document Line # |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 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 |
| 7 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | General Ledger Unit |
| 9 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 10 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 11 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 12 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 13 | 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.
Y/N Table Edit |