HCR_JOB_RQC(SQL Table) |
Index Back |
|---|---|
HCR_JOB_RQCRequester Comments - Fluid Job Action |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HCR_ACTN_SEQN |
Number(3,0) | SMALLINT NOT NULL | Sequence number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | HCR_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | used in requester comments job action |
| 7 | ACTIONDTTM | DateTime(26) | TIMESTAMP | Datetime action was taken on a worklist |
| 8 | HCR_JOB_WIP_STATUS |
Character(3) | VARCHAR2(3) NOT NULL |
Job Data request work in progress
CDE=Correction Denied CIN=Correction In-Progress COR=Corrected CRP=Correction Row Present DEL=Deleted DEN=Denied INI=In-Progress PBE=Rework PBN=Rework PRO=Completed PUS=Rework WIC=Withdrawn WIT=Withdrawn |
| 9 | HCR_CMNT_DSP | Character(1) | VARCHAR2(1) NOT NULL | requester comments Jobaction |
| 10 | EMPLID_CURR_APPR | Character(11) | VARCHAR2(11) NOT NULL | Stores the Employee ID of the Current Approver in Federal Self-Service Transactions. |
| 11 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 12 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 13 | HCR_COMMENTS | Long Character | CLOB | Captures comments in Requester comments,JobAction |