HP_ENCSUSPP_VW(SQL View) |
Index Back |
|---|---|
Encumbrance Suspense ViewView that provides level 0 information of pre-encumbrance earning records that used a suspense account |
| SELECT DISTINCT A.SETID , A.DEPTID , A.FISCAL_YEAR , %Substring(A.ENCUMB_PROC_TYPE,1,1) , A.POSITION_NBR , A.HP_KK_DOC_ID , A.HP_KK_DOC_LINE_NBR , A.POSITION_POOL_ID , A.SETID_JOBCODE , A.JOBCODE FROM PS_ENCUMB_DIST A WHERE A.ENCUMB_PROC_TYPE = 'PE' AND A.ENCUMB_POSTED = 'N' AND A.ENCUMBERED_AMT <> 0 AND A.FISCAL_YEAR = A.HP_BUDGET_YEAR AND A.ACCT_CD IN ( SELECT B.HP_ACCT_CD_SUSPNS FROM PS_DEPTBDGT_SUSPNS B WHERE B.SETID = A.SETID AND B.DEPTID = A.DEPTID AND B.FISCAL_YEAR = A.FISCAL_YEAR) |
| # | 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_ENCUMB_PROC |
Character(1) | VARCHAR2(1) NOT NULL |
Indicate the encumbrance process on Budget Actuals
E=Encumbrance P=Pre-encumbrance R=Requisition |
| 5 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 6 | HP_KK_DOC_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Commitment Control Document ID |
| 7 | HP_KK_DOC_LINE_NBR |
Number(3,0) | SMALLINT NOT NULL | Commitment Control Document Line # |
| 8 | POSITION_POOL_ID |
Character(3) | VARCHAR2(3) NOT NULL |
Position Pool ID
Prompt Table: POOL_TBL |
| 9 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL |
Job Code Set ID
Prompt Table: SET_JOB_DEP_VW |
| 10 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL |
Job Code
Prompt Table: JOBCODE_TBL |