SAD_BPV_INDEX_IDSAD_BPV_MSGUUIDSEQNUMDefault Value: 1
Prompt Table: SAD_SBBORGID_VW
Prompt Table: SAD_BPV_SBB_ST
Prompt Table: SAD_SBB_HEG_VW
C=Course
E=Elective
K=Elective
P=Program
T=Testimony
SAD_BPV_ACC_TST(SQL Table) |
Index Back |
|---|---|
BPV SBB Acceptation Tester |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_BPV_INDEX_ID |
Character(40) | VARCHAR2(40) NOT NULL | Transaction Index ID |
| 2 | SAD_BPV_MSGUUID |
Character(50) | VARCHAR2(50) NOT NULL | Message ID |
| 3 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
| 4 | EXTERNAL_SYSTEM_ID | Character(20) | VARCHAR2(20) NOT NULL |
External System ID
Prompt Table: SAD_SBBORGID_VW |
| 5 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 6 | SAD_BPV_SBB_STAT | Character(3) | VARCHAR2(3) NOT NULL |
Status Internship Company
Prompt Table: SAD_BPV_SBB_ST |
| 7 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table: SAD_SBB_HEG_VW |
| 8 | SCC_HEGIS_TYPE_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Hegis Code Type
C=Course E=Elective K=Elective P=Program T=Testimony |
| 9 | START_DATE | Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |
| 11 | SAD_BPV_STAT_LBD | Character(30) | VARCHAR2(30) NOT NULL | Historic Status |