GVT_RQSN_CERTIF(SQL Table) |
Index Back |
|---|---|
Certificate of Eligibles |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | GVT_RQSN_CERT_NBR | Character(10) | VARCHAR2(10) NOT NULL | Certificate of Eligibles Nbr |
| 4 | GVT_RQSN_CERT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Source
I=Generated Internally O=Requested from OPM |
| 5 | GVT_RQSN_CERT_STS | Character(1) | VARCHAR2(1) NOT NULL |
Certificate Status
C=Cancelled F=Forwarded by Selecting Off I=Issued/Received M=Pending Min Qual Determination P=Pending Ratings R=Requested S=Re-Issued T=Returned by Selecting Official U=Returned to Issuer W=Waiting Applicants |
| 6 | DT_REQUESTED | Date(10) | DATE | Date of Request |
| 7 | DT_ISSUED | Date(10) | DATE | Issue Date |
| 8 | DT_RECVD | Date(10) | DATE | Date Received |
| 9 | DT_RETURNED | Date(10) | DATE | Date Returned |
| 10 | DT_DUE | Date(10) | DATE | Due Date |
| 11 | GVT_DT_EXTENDED | Date(10) | DATE | Extension Date |
| 12 | GVT_DT_SENT_TO_SO | Date(10) | DATE | Date Sent to SO |
| 13 | GVT_DT_RET_FRM_SO | Date(10) | DATE | Date Returned from SO |
| 14 | GVT_RQSN_TIE_BREAK | Number(3,0) | SMALLINT NOT NULL | Tie Break Nbr |