SAD_BPVINST_NLD(SQL Table) |
Index Back |
|---|---|
BPV Installation Options/* 20-3-2020 fix for bug 25886858 - added field for accreditation on elective modules */ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL |
Role User
Prompt Table: PSROLEDEFN_VW |
| 2 | SAD_INT_CONTR_NLD | Character(16) | VARCHAR2(16) NOT NULL | Internal contract |
| 3 |  SCC_EXTERNAL_SYS |
Character(3) | VARCHAR2(3) NOT NULL |
External System
Prompt Table: SSR_BR_EXTSY_VW |
| 4 | EXT_ORG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Organization Type
Default Value: SCHL Prompt Table: SCC_ORG_TYP_TBL |
| 5 | PROPRIETORSHIP | Character(4) | VARCHAR2(4) NOT NULL |
Proprietorship
OTHR=Other PRIV=Private PUBL=Public RELG=Religious Default Value: PUBL |
| 6 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |
| 7 | SAD_BPV_OTYPE_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Organization type
Prompt Table: SAD_BPV_OTYP_VW |
| 8 | SAD_BPV_SCORE | Number(3,0) | SMALLINT NOT NULL | Score |
| 9 | ACAD_ORG | Character(10) | VARCHAR2(10) NOT NULL |
Academic Organization
Prompt Table: SAD_ACAD_O_SCTY |
| 10 | SAD_BPV_EXTORG_DT | Date(10) | DATE | Ext Org ID Date |
| 11 | SAD_GE_HEGISCD_NLD | Character(8) | VARCHAR2(8) NOT NULL |
Generic Elective Hegis Accred.
Prompt Table: SSR_HEGISCD_NLD |