R_APP008(SQL Table) |
Index Back |
|---|---|
Temp Table for SQR APP008This is a temporary work area used by the system during SQR report processing for report APP008. You don't need to touch this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | APPLID | Character(11) | VARCHAR2(11) NOT NULL | External Job Applicant ID |
| 2 | APP_DT | Date(10) | DATE | Date an application was submitted |
| 3 | BASISCODE | Character(11) | VARCHAR2(11) NOT NULL | BasisCode |
| 4 | PTS | Character(4) | VARCHAR2(4) NOT NULL | Pts |
| 5 | COMPPTS | Character(4) | VARCHAR2(4) NOT NULL | Competency Points |
| 6 | ACCOMPPTS | Character(4) | VARCHAR2(4) NOT NULL | Accomplishment Points |