EMPLIDCOMM_DTTM1=Add Appointments
2=Delete Appointments
1=Enrollment Appointment
2=Validation Appointment
R_SRAPPT_COMM(SQL Table) |
Index Back |
|---|---|
Enrollment Apptmnt Temp TableHolds information that will be processed by letter gen for communicating appointment data. |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SSR_APPT_STDT_BLCK | Character(6) | VARCHAR2(6) NOT NULL | Student Appointment Block |
| 5 | SSR_DESCR_STD_BLCK | Character(30) | VARCHAR2(30) NOT NULL | Student Block Descr |
| 6 | SSR_APPT_PROC_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Assign Appointment Process Mode.
1=Add Appointments 2=Delete Appointments |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | SSR_APPT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Appointment Type
1=Enrollment Appointment 2=Validation Appointment |
| 9 | SSR_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 10 | SSR_APPT_BLOCK | Character(6) | VARCHAR2(6) NOT NULL | Appointment Block |
| 11 | SSR_DESCR_AP_BLCK | Character(30) | VARCHAR2(30) NOT NULL | Appointment Block Descr |
| 12 | APPOINTMENT_NBR | Character(4) | VARCHAR2(4) NOT NULL | Appointment Nbr |
| 13 | APPT_START_DATE | Date(10) | DATE | Appointment Start Date |
| 14 | APPT_START_TIME | Time(15) | TIMESTAMP | Appointment Start Time |
| 15 | APPT_END_DATE | Date(10) | DATE | Appointment End Date |
| 16 | APPT_END_TIME | Time(15) | TIMESTAMP | Appointment End Time |