| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Default Value: SAD_BPV_CTR_NLD.EXT_ORG_ID
Prompt Table:
%EDITTABLE
|
| 2 |
ORG_LOCATION |
Number(3,0) |
SMALLINT NOT NULL |
Location Nbr
Default Value: SAD_BPV_CTR_NLD.ORG_LOCATION
Prompt Table:
%EDITTABLE3
|
| 3 |
HEGIS_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
HEGIS Code
Prompt Table:
%EDITTABLE2
|
| 4 |
SAD_INT_CONTR_NLD |
Character(16) |
VARCHAR2(16) NOT NULL |
Internal contract
Prompt Table:
%EDITTABLE6
|
| 5 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
SAD_BPV_INST_VW
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
%EDITTABLE5
|
| 7 |
ACTION_DT |
Date(10) |
DATE NOT NULL |
Action Date
Default Value: %date
|
| 8 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
STDNT_CAREER
|
| 9 |
STDNT_CAR_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Student Career Nbr
Prompt Table:
%EDITTABLE7
|
| 10 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Prompt Table:
%EDITTABLE3
|
| 11 |
SAD_BR_BPV_SEQ_NLD |
Number(2,0) |
SMALLINT NOT NULL |
BPV sequence number
|
| 12 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 13 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: SAD_BPV_CTR_NLD.START_DATE
|
| 14 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
Default Value: SAD_BPV_CTR_NLD.END_DATE
|
| 15 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 16 |
ACAD_LOAD_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
Prompt Table:
%EDITTABLE4
|
| 17 |
SAD_CONTR_LNGT_NLD |
Number(3,0) |
SMALLINT NOT NULL |
Contract length in weeks
|
| 18 |
SAD_CONTR_PRT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract printed
N=Not Printed
P=Printed
S=Temporary Contract (BPVO)
Default Value: N
|
| 19 |
SAD_WEEK_HRS_NLD |
Number(2,0) |
SMALLINT NOT NULL |
Number of hours per week
|
| 20 |
INSTRUCTOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Instructor ID
Default Value: SAD_BPV_CTR_NLD.INSTRUCTOR_ID
Prompt Table:
SAD_INSTRUCT_VW
|
| 21 |
ORG_CONTACT |
Number(4,0) |
SMALLINT NOT NULL |
Contact Nbr
Default Value: SAD_BPV_CTR_NLD.ORG_CONTACT
Prompt Table:
SAD_BPV_ORG_LVW
|
| 22 |
SAD_ORG_CONTA2_NLD |
Number(4,0) |
SMALLINT NOT NULL |
Contact nbr 2
Default Value: SAD_BPV_CTR_NLD.SAD_ORG_CONTA2_NLD
Prompt Table:
SAD_BPV_ORG_LVW
|
| 23 |
SAD_ORG_LOC_ML_NLD |
Number(3,0) |
SMALLINT NOT NULL |
Location number
Default Value: SAD_BPV_CTR_NLD.SAD_ORG_LOC_ML_NLD
Prompt Table:
ORG_LOCATION
|
| 24 |
PRINT_DATE |
Date(10) |
DATE |
Print Date
|
| 25 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
|
| 26 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 27 |
SAD_BPV_SG_EMP_NLD |
Date(10) |
DATE |
Date signature emplid
|
| 28 |
SAD_BPV_SG_PAR_NLD |
Date(10) |
DATE |
Date signature parent
|
| 29 |
SAD_BPV_SG_INS_NLD |
Date(10) |
DATE |
Date signature institution
|
| 30 |
SAD_BPV_SG_EOR_NLD |
Date(10) |
DATE |
Date signature external org
|
| 31 |
SAD_BPV_SG_LO_NLD |
Date(10) |
DATE |
Date signature LO
|
| 32 |
SAD_LETTER_PRT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Letter printed
N=Letter not printed
P=Letter printed
Default Value: N
|
| 33 |
LETTER_PRINTED_DT |
Date(10) |
DATE |
Date letter was printed
|
| 34 |
STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status Indicator
A=Active
I=Inactive
Default Value: A
|
| 35 |
CANCEL_DATE |
Date(10) |
DATE |
Deduction Cancel Date
|
| 36 |
SAD_BPV_REASON_NLD |
Character(3) |
VARCHAR2(3) NOT NULL |
Closure reason
Prompt Table:
SAD_BPV_RSN_NLD
|
| 37 |
SAD_EO_ID_DET_NLD |
Character(11) |
VARCHAR2(11) NOT NULL |
Outsourcing company
Prompt Table:
SAD_BPV_ORG_SRC
|
| 38 |
SAD_ORGLC_DTL_NLD |
Number(3,0) |
SMALLINT NOT NULL |
Outsourcing location
Prompt Table:
SAD_DET_LOV_VW
|
| 39 |
SAD_PR_TSTSTAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Print status
|
| 40 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 41 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 42 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 43 |
NAME_ROYAL_PREFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Prefix
|
| 44 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 45 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 46 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 47 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 48 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 49 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 50 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 51 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
|
| 52 |
SSR_NATIONAL_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
GBA Nationality Code
|
| 53 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 54 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 55 |
ADDRESS3_2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 56 |
NUM1_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1 Other
|
| 57 |
NUM2_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2 Other
|
| 58 |
POSTAL2 |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 59 |
CITY2 |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 60 |
DESCR50_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 61 |
ADDRESS3_AC |
Character(55) |
VARCHAR2(55) NOT NULL |
Alternate Character Address 3
|
| 62 |
SAD_NUM1_OLD_NLD |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 63 |
SAD_NUM2_OLD_NLD |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 64 |
POSTAL2_GER |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 65 |
CITY2_GER |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 66 |
MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager ID
|
| 67 |
DESCRFORMAL |
Character(50) |
VARCHAR2(50) NOT NULL |
Formal Description field
|
| 68 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
|
| 69 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
|
| 70 |
NAME_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Suffix
|
| 71 |
FIRST_NAME_TOEFL |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 72 |
MIDDLE_NAME_TOEFL |
Character(30) |
VARCHAR2(30) NOT NULL |
TOEFL - Middle Name
|
| 73 |
LAST_NAME_TOEFL |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 74 |
NAME_ROYAL_SUFFIX |
Character(15) |
VARCHAR2(15) NOT NULL |
Name Royal Suffix
|
| 75 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 76 |
SCC_LOB_CODE_NLD |
Character(10) |
VARCHAR2(10) NOT NULL |
Lob Code
|
| 77 |
DESCR2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr2
|
| 78 |
DESCR3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr 3
|
| 79 |
FIRST_NAME_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Field First_Name_CD stores the value of the first name in the community directory.
|
| 80 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 81 |
DESCR4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr 4
|
| 82 |
SAD_NAT_ORGCTR_NLD |
Character(40) |
VARCHAR2(40) NOT NULL |
External Contract field augmented to 40 positions
|
| 83 |
DESCR5 |
Character(30) |
VARCHAR2(30) NOT NULL |
This field is used in a complex query that shows many descr fields.
|
| 84 |
ADDRESS3_PS |
Character(55) |
VARCHAR2(55) NOT NULL |
Address Line 3
|
| 85 |
SAD_NUM1_NLD |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 86 |
SAD_NUM2_NLD |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 87 |
POSTAL3_GER |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal Code
|
| 88 |
CITY3_GER |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 89 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 90 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 91 |
ADDRESS3_OTHER |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3 Other
|
| 92 |
SAD_NUM1_1_NLD |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 93 |
SAD_NUM2_1_NLD |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 94 |
CITY_PS |
Character(30) |
VARCHAR2(30) NOT NULL |
City - PaySlip
|
| 95 |
POSTAL_PS |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal - PaySlip
|
| 96 |
SAD_BR_BPV_CRT_DT |
Date(10) |
DATE |
BPV End Date for BRON
|
| 97 |
SAD_TOTHRS_BPV_NLD |
Number(4,0) |
SMALLINT NOT NULL |
Total nbr of BPV Hours
|
| 98 |
DESCRLONG |
Long Character |
CLOB |
Long Description
Default Value: SAD_BPV_CTR_NLD.DESCRLONG
|
| 99 |
ACAD_PROG_DUAL |
Character(5) |
VARCHAR2(5) NOT NULL |
Dual Academic Program
|
| 100 |
AKA_HEGIS_CODE |
Character(8) |
VARCHAR2(8) NOT NULL |
AKA Hegis Code
|
| 101 |
SAD_BR_EX_BRON_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude From Sending To BRON
Y/N Table Edit
Default Value: N
|
| 102 |
SAD_BR_NO_DEL_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Do Not Send Deletion To BRON
Y/N Table Edit
Default Value: N
|
| 103 |
SAD_BPV_CONTR_NBR |
Character(16) |
VARCHAR2(16) NOT NULL |
Principal Contract Number
Prompt Table:
SAD_BPV_CNT_VW
|
| 104 |
SAD_BPV_REASON |
Long Character(1000) |
VARCHAR2(1000) |
Reason
|
| 105 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 106 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 107 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 108 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|