SAD_BPV_CONT_VW(SQL View) |
Index Back |
|---|
| SELECT A.EXT_ORG_ID , A.SAD_INT_CONTR_NLD , A.ORG_LOCATION , A.HEGIS_CODE , A.STRM , A.SAD_NAT_ORGCTR_NLD , A.DESCR50 , A.START_DATE , A.END_DATE , A.SAD_INTSHP_APP_NLD , A.INSTRUCTOR_ID , A.ORG_CONTACT , A.SAD_ORG_CONTA2_NLD , A.SAD_ORG_LOC_ML_NLD , A.SAD_NATORG_ID_NLD , A.SAD_CONTR_LNGT_NLD , A.SAD_WEEK_HRS_NLD , A.MAX_STUDENTS , A.SAD_TOTHRS_BPV_NLD FROM PS_SAD_BPV_CTR_NLD A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EXT_ORG_ID |
Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
| 2 | SAD_INT_CONTR_NLD |
Character(16) | VARCHAR2(16) NOT NULL | Internal contract |
| 3 | ORG_LOCATION | Number(3,0) | SMALLINT NOT NULL |
Location Nbr
Prompt Table: SAD_BPV_LOC_NLD |
| 4 | HEGIS_CODE | Character(8) | VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table: HEGIS_CODE_TBL |
| 5 | STRM | Character(4) | VARCHAR2(4) NOT NULL |
Term
Prompt Table: TERM_VAL_TBL |
| 6 | SAD_NAT_ORGCTR_NLD | Character(40) | VARCHAR2(40) NOT NULL | External Contract field augmented to 40 positions |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 9 | END_DATE | Date(10) | DATE | End Date |
| 10 | SAD_INTSHP_APP_NLD | Character(2) | VARCHAR2(2) NOT NULL |
Approved by nat. organization
AC=Accredited IC=In consideration NA=Not accredited NM=Nominated RQ=AccreditationRequested |
| 11 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SAD_INSTRUCT_VW |
| 12 | ORG_CONTACT | Number(4,0) | SMALLINT NOT NULL |
Contact Nbr
Prompt Table: SAD_BPV_OCO_NLD |
| 13 | SAD_ORG_CONTA2_NLD | Number(4,0) | SMALLINT NOT NULL |
Contact nbr 2
Prompt Table: SAD_BPV_OCO_NLD |
| 14 | SAD_ORG_LOC_ML_NLD | Number(3,0) | SMALLINT NOT NULL |
Location number
Prompt Table: SAD_BPV_LOC_NLD |
| 15 | SAD_NATORG_ID_NLD | Character(11) | VARCHAR2(11) NOT NULL |
National organization
Prompt Table: SAD_LO_VW |
| 16 | SAD_CONTR_LNGT_NLD | Number(3,0) | SMALLINT NOT NULL | Contract length in weeks |
| 17 | SAD_WEEK_HRS_NLD | Number(2,0) | SMALLINT NOT NULL | Number of hours per week |
| 18 | MAX_STUDENTS | Number(3,0) | SMALLINT NOT NULL | Maximum Nbr of Students |
| 19 | SAD_TOTHRS_BPV_NLD | Number(4,0) | SMALLINT NOT NULL | Total nbr of BPV Hours |