| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
Prompt Table:
ECQUEUE
|
| 2 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 3 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
Default Value: I
|
| 4 |
TRANS_CNTRL_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Transaction Set Control Number
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 6 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 7 |
SSN |
Character(9) |
VARCHAR2(9) NOT NULL |
Social Security #
|
| 8 |
LAST_NAME_EDI |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 9 |
FIRST_NAME_EDI |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 10 |
MIDDLE_INIT_EDI |
Character(30) |
VARCHAR2(30) NOT NULL |
Middle Initial
|
| 11 |
TRANSACTION_DATE |
Date(10) |
DATE |
TRANSACTION_DATE
|
| 12 |
EDI_TRANS_TIME |
Character(15) |
VARCHAR2(15) NOT NULL |
Transaction Time
|
| 13 |
TRANSACTN_TYPE_EDI |
Character(2) |
VARCHAR2(2) NOT NULL |
Inbound Transaction Type
00=Original
05=Replace
06=Confirmation
07=Duplicate
11=Response
15=Re-Submission
18=Reissue
ZZ=Mutually Defined
|
| 14 |
EDI_TRANS_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Edi Transaction Type
DP=District to Postsecondary
PS=Postsecondary Student Record
|
| 15 |
STATUS_RSN_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Status Reason
|
| 16 |
EDI_REF_NBR_QUAL |
Character(2) |
VARCHAR2(2) NOT NULL |
EDI Reference Number Qualifier
30=United States Govern Visa Nbr
48=Agency's Student Number
49=Family Unit Number
4A=Personal Identification Number
50=State Student ID Number
56=Corrected SSN
57=Prior Incorrect SSN
A6=Employee Identification Number
C0=Canadian Social Insurance Nbr
E4=Charge Card
LR=Local Student Id Nbr
MV=Migrant Number
SY=Social Security Number
V2=Visa Type
V4=State Department I-20 Form Nbr
V5=State Depart IAP-66 Form Nbr
ZZ=Mutually Defined
|
| 17 |
EDI_REF_NBR |
Character(30) |
VARCHAR2(30) NOT NULL |
EDI Reference Number
|
| 18 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 19 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 20 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 21 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 22 |
BIRTHCOUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Birth Country
Prompt Table:
COUNTRY_TBL
|
| 23 |
BIRTHSTATE |
Character(6) |
VARCHAR2(6) NOT NULL |
Birth State
Prompt Table:
BIRTHSTATE_VW
|
| 24 |
ETHNIC_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Ethnic Group
1=White
2=Black/African American
3=Hispanic/Latino
4=Asian
5=American Indian/Alaska Native
6=Not Specified
7=Native Hawaiian/Oth Pac Island
A=American Indian/Alaskan Native
B=Asian or Pacific Islander
C=Black, not of Hispanic origin
D=Hispanic
E=White, not of Hispanic origin
F=Asian Indian
G=Chinese
H=Filipino
J=Guamanian
K=Hawaiian
L=Japanese
M=Korean
N=Samoan
P=Vietnamese
Q=All Other Asian o Pacific Is
Y=Not Hispanic in Puerto Rico
|
| 25 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table:
ADM_USA_CIT_VW
|
| 26 |
CITIZEN_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country of Citizenship
Prompt Table:
COUNTRY_TBL
|
| 27 |
UNT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Unit Type
ADU=Adult
CAR=Carnegie Units
CEU=Continuing Education Unit
NCR=No Credit
OTH=Non-Standard units
QTR=Quarter Units
SEM=Semester Units
UKN=Unknown
UNT=Units
VOC=Vocational
|
| 28 |
COURSE_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Course Level
11=Grade 11
12=Grade 12
AP=Advanced Placement
DR=Graduate/Doctoral
FR=Freshman
GR=Graduate
HN=Honors
IB=International Baccalaureate
JR=Junior
LD=Lower Division
MS=Graduate/Master
RG=Regular
SO=Sophomore
SR=Senior
UD=Upper Division
|
| 29 |
CUM_SUMMARY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Cumulative Summary Indicator
|
| 30 |
EXT_GPA |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
External GPA
|
| 31 |
UNT_ATMP_TOTAL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Total Units Attempted
|
| 32 |
UNT_COMP_TOTAL |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Total Completed Units
|
| 33 |
CLASS_RANK |
Number(5,0) |
INTEGER NOT NULL |
Class Rank
|
| 34 |
CLASS_SIZE |
Number(5,0) |
INTEGER NOT NULL |
Class Size
|
| 35 |
HOURS_EARNED |
Signed Number(12,6) |
DECIMAL(10,6) NOT NULL |
Hours Earned
|
| 36 |
DATE_TIME_PERIOD |
Character(35) |
VARCHAR2(35) NOT NULL |
Date Time Period
|
| 37 |
EDI_NAM_COMPNT |
Character(2) |
VARCHAR2(2) NOT NULL |
Name Component
|
| 38 |
EDI_NAME |
Character(60) |
VARCHAR2(60) NOT NULL |
Name
|
| 39 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 40 |
SEARCH_ORDER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.
|
| 41 |
MATCH_NBR |
Number(6,0) |
INTEGER NOT NULL |
Number of Matches
|
| 42 |
DATE_LOADED |
Date(10) |
DATE |
Date Loaded
|
| 43 |
DATE_POSTED |
Date(10) |
DATE |
Date Posted
|
| 44 |
EDIT_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Processsing Options
C=Complete
E=Error
P=Perform
Default Value: P
|
| 45 |
SRCH_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match processing option
C=Complete
E=Error
P=Perform
Default Value: P
|
| 46 |
POST_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Processing Option
A=Awaiting Search/Match
D=Delete Existing ID
E=Error
N=New ID Add
P=Purge
T=Take No Action
U=Update Existing ID
Default Value: A
Prompt Table:
XL_POST_PROC_VW
|
| 47 |
LAST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Error
Y/N Table Edit
Default Value: N
|
| 48 |
FIRST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Error
Y/N Table Edit
Default Value: N
|
| 49 |
TEST_COMP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Component Error
Y/N Table Edit
Default Value: N
|
| 50 |
COURSE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Course Error
Y/N Table Edit
Default Value: N
|
| 51 |
DISABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Default Value: N
|
| 52 |
FT_STUDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Full-Time Student
Y/N Table Edit
Default Value: N
|
| 53 |
HIGHEST_EDUC_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Highest Education Level
Default Value: A
|
| 54 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 55 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 56 |
NAME_PREFIX |
Character(4) |
VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table:
NAME_PREFIX_TBL
|
| 57 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
|
| 58 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|
| 59 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_REGION_TBL
|
| 60 |
ETHNIC_GRP_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table:
ETHNIC_GRP_TBL
Set Control Field: REG_REGION
|