R_SRPCATNP(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
4 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
5 | ATTEND_STDNT_ENRL | Character(1) | VARCHAR2(1) NOT NULL | Populate from Student Enroll |
6 | COMMIT_FREQUENCY | Number(3,0) | SMALLINT NOT NULL | Commit Frequency |
7 | ATTEND_CR_UPD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag used on class generation panels to determine if attendance rosters should be created or just updated.
A=Update Attendance/Active Only C=Create Attendance U=Update Attendance/All Students |
8 | ATTEND_FROM_DATE | Date(10) | DATE | Date used on attendence template generation panels to start the generation of panels. |
9 | ATTEND_TO_DATE | Date(10) | DATE | Date used on attendence template generation panels to stop the generation of panels. |