HP_KK_DOC_IDHP_KK_DOC_LINE_NBREMPLIDPrompt Table: PERSON
EMPL_RCDPrompt Table: PER_ORG_ASGN_VW
Y/N Table Edit
HP_DOC_JOB_VW(SQL View) |
Index Back |
|---|---|
Job log viewSearch view budget check employee log based on Doc ID xref. |
| SELECT D.HP_KK_DOC_ID , D.HP_KK_DOC_LINE_NBR , J.EMPLID , J.EMPL_RCD , J.HP_UPD_IN_PROGRESS FROM PS_HP_BDCK_LOG_JOB J , PS_ENCUMB_DIST E , PS_HP_DOC_ID_XREF D WHERE D.HP_KK_DOC_ID = E.HP_KK_DOC_ID AND D.HP_KK_DOC_LINE_NBR = E.HP_KK_DOC_LINE_NBR AND E.EMPLID = J.EMPLID AND E.EMPL_RCD = J.EMPL_RCD |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN_VW |
| 5 | 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 |