SSR_APTSYRQ_HVW(SQL View) |
Index Back |
|---|---|
APT Sync Req Hdr Search View |
| SELECT ssr_aptsync_reqnbr , run_cntl_id , ssr_aptsync_reqsrc , process_instance , ssr_aptsy_proc_st , ssr_apt_syn_create , ssr_apt_syn_delete , ssr_apt_syn_crseeq , scc_row_upd_oprid , scc_row_upd_dttm , scc_row_add_oprid , scc_row_add_dttm FROM PS_SSR_APTSYRQ_HDR |
| # | 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
Prompt Table: SSR_APTSYRQH2VW |
| 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 |
| 8 | SSR_APT_SYN_CRSEEQ | Character(1) | VARCHAR2(1) NOT NULL |
Use Course Equivalency
Default Value: Y |
| 9 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 10 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |
| 11 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 12 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created on |