SSR_APTSYRQ_HDR(SQL Table) |
Index Back |
---|---|
APT Sync Request Header |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_APTSYNC_REQNBR | Number(11,0) | DECIMAL(11) NOT NULL | APT Sync Request Nbr |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SSR_APTSYNC_REQSRC | Character(2) | VARCHAR2(2) NOT NULL |
APT Sync Request Source
SM=APT Sync - Manual Entry SP=APT Sync - Pop Select |
4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
5 | SSR_APTSY_PROC_ST | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Req Process Status
E=Errors M=Messages P=Pending S=Success Default Value: P |
6 | SSR_APT_SYN_CREATE | Character(1) | VARCHAR2(1) NOT NULL |
Create APT Items
Y/N Table Edit Default Value: Y |
7 | SSR_APT_SYN_DELETE | Character(1) | VARCHAR2(1) NOT NULL |
Delete APT Course
D=Set to Dropped Status E=As Defined in Enrol Category R=Set to Planned status Default Value: E |
8 | SSR_APT_SYN_CRSEEQ | Character(1) | VARCHAR2(1) NOT NULL |
Use Course Equivalency
Y/N Table Edit Default Value: Y |
9 | SSR_RSLT_TYPE | Character(20) | VARCHAR2(20) NOT NULL | Result Type |
10 | SSR_RES_MAP_ID | Character(12) | VARCHAR2(12) NOT NULL | Result Scale |
11 | SSR_APT_SYN_REMOVE | Character(1) | VARCHAR2(1) NOT NULL |
Remove APT Sync Gen Sub
Y/N Table Edit Default Value: N |
12 | SSR_APT_SYN_REMOPT | Character(1) | VARCHAR2(1) NOT NULL |
Remove APT Sync Gen Sub Option
A=Always O=Only on DD and Deleted TC Default Value: A |
13 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
14 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
15 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
16 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |