SSR_RNC_CART(SQL Table) |
Index Back |
|---|---|
CART Response TableCART Response table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SSR_CART_SETUP |
| 4 | SSR_CART_REQ_ID | Number(12,0) | DECIMAL(12) NOT NULL |
CART request id
Prompt Table: SSR_CART_SUS_VW |
| 5 | SSR_CENSUS_STRT_DT | Date(10) | DATE NOT NULL | Australia DEST Processing |
| 6 | SSR_CENSUS_END_DT | Date(10) | DATE NOT NULL | Australia DEST Processing |
| 7 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
| 8 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business CAMP=Campus CELL=Mobile DORM=Dormitory FAX=FAX HOME=Home MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex WORK=Work |
| 9 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |