EMPLIDCOMM_DTTMSTRMCLASS_NBRR_SRTRMDF(SQL Table) |
Index Back |
|---|---|
Temp Table for Term DeficiencyThis table contains entries used to create Term Deficiency Letters for Student Records. This table contains data that will be used in the letters generated by Letter Gen. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMM_DTTM |
DateTime(26) | TIMESTAMP | Communication DateTime |
| 3 | STRM |
Character(4) | VARCHAR2(4) NOT NULL | Term |
| 4 | CLASS_NBR |
Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 5 | SUBJECT | Character(8) | VARCHAR2(8) NOT NULL | Subject Area |
| 6 | CATALOG_NBR | Character(10) | VARCHAR2(10) NOT NULL | Catalog Nbr |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | GRADE | Character(3) | VARCHAR2(3) NOT NULL | Salary Grade |