|
SELECT A.EMPLID ,A.ACCOMPLISHMENT ,A.DT_ISSUED ,A.MAJOR_CODE ,B.ACCOMP_CATEGORY , %subrec(TESTS_SBR,A) , %subrec(LIC_CERT_SBR,A) , %subrec(LANGUAGE_SBR,A) , %subrec(MEMBERSHIP_SBR,A) , %subrec(EDUCATION_SBR,A) , %subrec(HONOR_AWARD_SBR,A) , %subrec(EDUCATN_FED_SBR,A) , A.SELECT_CMP FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 2 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table:
%RECNAME_EDIT
|
| 3 |
DT_ISSUED |
Date(10) |
DATE |
Issue Date
|
| 4 |
MAJOR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Major Code
Prompt Table:
MAJOR_TBL
|
| 5 |
ACCOMP_CATEGORY |
Character(3) |
VARCHAR2(3) NOT NULL |
Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test
|
| 6 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 7 |
PASSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Passed Test
Y/N Table Edit
Default Value: N
|
| 8 |
LICENSE_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
License/Certification Number
|
| 9 |
ISSUED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Issued By
|
| 10 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 11 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 12 |
EXPIRATN_DT |
Date(10) |
DATE |
Expiration Date
|
| 13 |
LICENSE_VERIFIED |
Character(1) |
VARCHAR2(1) NOT NULL |
License Verified
Y/N Table Edit
Default Value: N
|
| 14 |
RENEWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Renewal in Progress
Y/N Table Edit
Default Value: N
|
| 15 |
NATIVE_LANGUAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Native Language
Y/N Table Edit
Default Value: N
|
| 16 |
TRANSLATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Translate
Y/N Table Edit
Default Value: N
|
| 17 |
TEACHER |
Character(1) |
VARCHAR2(1) NOT NULL |
Able to Teach
Y/N Table Edit
Default Value: N
|
| 18 |
SPEAK_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Speaking Proficiency
1=Low
2=Moderate
3=High
|
| 19 |
READ_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reading Proficiency
1=Low
2=Moderate
3=High
|
| 20 |
WRITE_PROFICIENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Writing Proficiency
1=Low
2=Moderate
3=High
|
| 21 |
EVALUATION_DT |
Date(10) |
DATE |
Evaluation Date
|
| 22 |
MANDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate
|
| 23 |
MANDATE_FUNCTION |
Character(15) |
VARCHAR2(15) NOT NULL |
Mandate Position
|
| 24 |
MANDATE_BEGIN_DATE |
Date(10) |
DATE |
Mandate Begin Date
|
| 25 |
MANDATE_END_DATE |
Date(10) |
DATE |
Mandate End Date
|
| 26 |
MAJOR |
Character(30) |
VARCHAR2(30) NOT NULL |
Major
|
| 27 |
IPE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intern. Professional Education
Y/N Table Edit
Default Value: N
|
| 28 |
AVERAGE_GRADE |
Character(5) |
VARCHAR2(5) NOT NULL |
Average Grade
|
| 29 |
EDUCATOR |
Character(50) |
VARCHAR2(50) NOT NULL |
Educator
|
| 30 |
GRADUATE_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduated
Y/N Table Edit
Default Value: Y
|
| 31 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
Prompt Table:
SCHOOL_TBL
|
| 32 |
SCHOOL |
Character(30) |
VARCHAR2(30) NOT NULL |
School Name
|
| 33 |
STATE_OTHER |
Character(6) |
VARCHAR2(6) NOT NULL |
State Other
Prompt Table:
STATE_NAMES_OTH
|
| 34 |
COUNTRY_OTHER |
Character(3) |
VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table:
COUNTRY_TBL
|
| 35 |
TERMINAL_DEGREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminal Degree for Discipline
Y/N Table Edit
Default Value: N
|
| 36 |
GRANTOR |
Character(20) |
VARCHAR2(20) NOT NULL |
Grantor
|
| 37 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 38 |
GVT_CREDIT_HOURS |
Character(3) |
VARCHAR2(3) NOT NULL |
Credit Hours
|
| 39 |
GVT_CRED_HRS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Hours Type
|
| 40 |
GPA |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
GPA
|
| 41 |
YR_ACQUIRED |
Number(4,0) |
SMALLINT NOT NULL |
Year Acquired
|
| 42 |
SELECT_CMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Competency for Search
|