EMPLIDACCOMPLISHMENTPrompt Table: NVQ_VW
A=Achieved
C=Cancelled
E=Enrolled
P=Previous Achievement
R=Reviewed
NVQ_PROG(SQL Table) |
Index Back |
|---|---|
NVQs in ProgressThis UK specific table tracks the overall progress of an employee towards achieving a particular NVQ. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table: NVQ_VW |
| 3 | NVQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The status of the employee's NVQ
A=Achieved C=Cancelled E=Enrolled P=Previous Achievement R=Reviewed |
| 4 | NVQ_START_DT | Date(10) | DATE | NVQ Start Date |
| 5 | NVQ_COMP_DT | Date(10) | DATE | NVQ Completion Date |
| 6 | NVQ_CERT_DT | Date(10) | DATE | Certificate Award Date |
| 7 | NVQ_CAND_NBR | Character(16) | VARCHAR2(16) NOT NULL | Registration Number |
| 8 | NVQ_CAND_DT | Date(10) | DATE | Registration Date |