| # |
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)
|
| 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 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SA_TEST_TBL
|
| 6 |
EDI_SPEEDE_TST_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
SPEEDE Subtest Code
|
| 7 |
EDI_TEST_DT |
Character(10) |
VARCHAR2(10) NOT NULL |
EDI Test Date
|
| 8 |
EDI_DT_TM_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Date Time Format Qualifier
CM=CCYYMM
CY=CCYY
D6=YYMMDD
D8=CCYYMMDD
YM=YYMM
YY=YY
|
| 9 |
TEST_DT |
Date(10) |
DATE |
Test Date
|
| 10 |
TEST_COMPONENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Test Component
Prompt Table:
SA_TCMP_REL_TBL
|
| 11 |
SCORE |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Test Score
|
| 12 |
EXT_ACAD_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
External Academic Level
0=Unknown
01=Pre-Eighth Grade
1=Eighth Grade
2=Ninth Grade
3=Tenth Grade
4=Eleventh Grade
5=Twelfth Grade
6=Postsecondary First Year
7=Postsecondary Sophomore
8=Postsecondary Junior
9=Postsecondary Senior
90=Post-Secondary
91=Postsecondary Professional
92=Postsecondary Master
93=Postsecondary Doctoral
94=Postdoctoral
A1=Basic User/Breakthrough (NLD)
A2=Basic User/Waystage (NLD)
B1=Independ. User/Threshold (NLD)
B2=Independ. User/Vantage (NLD)
C1=Prof. User/Effective (NLD)
C2=Proficient User/Master (NLD)
|
| 13 |
TEST_DT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Date Error
Y/N Table Edit
Default Value: N
|
| 14 |
TEST_COMP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Component Error
Y/N Table Edit
Default Value: N
|
| 15 |
TEST_COMP_1_PST |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Component #1 Post
Y/N Table Edit
Default Value: N
|
| 16 |
SCORE_QUAL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Score Qualifier
1=Scaled Score
2=Grade Equiv or Grade Lvl Ind
3=Standard Score
4=Raw Score
5=Percent of Items Correct
6=Mastery Score
7=Adj Class of Locally Def Scr
8=Stanine
9=Percentile
A=Normal Curve Equivalent
B=Equated Score
C=Pass/Fail
D=Equivalent Score
Z=Mutually Defined
|
| 17 |
TEST_LEVEL |
Character(30) |
VARCHAR2(30) NOT NULL |
Test Level
|
| 18 |
TRANS_ROW_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Row ID
|