PROCESS_INSTANCESSR_NOTIF_IDSSR_ENTITIES_UIDDefault Value: %Date
SSR_HM_NT_CHESS(SQL Table) |
Index Back |
|---|---|
Notifications CHESSN TableStores entity UIDs of students with allocated CHESSN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SSR_NOTIF_ID |
Character(36) | VARCHAR2(36) NOT NULL | Notification ID |
| 3 | SSR_ENTITIES_UID |
Number(31,0) | DECIMAL(31) NOT NULL | Notification Entities UID |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %Date |
| 6 | SSR_STDNT_CHESSN | Character(10) | VARCHAR2(10) NOT NULL | Commonwealth Higher Education Student Support Number (CHESSN) |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |