SAD_AMC_CD_TST (SQL Table)	Index Back
AMCAS Addln Cand Colg Inf File This contains all the colleges information from prior years before entering the medical school and is posted into this 'live' table.

SAD_AMC_CD_TST

(SQL Table)

AMCAS Addln Cand Colg Inf File

This contains all the colleges information from prior years before entering the medical school and is posted into this 'live' table.

Parent record: SAD_AMC_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 TEST_DT Date(10) DATE NOT NULL Test Date
Prompt Table: SAD_AMC_CD

3 TEST_NBR Number(2,0) SMALLINT NOT NULL Test Number

4 SERIES_CD_AMCAS Character(2) VARCHAR2(2) NOT NULL Series Code

5 NON_STND_IND_AMCAS Character(1) VARCHAR2(1) NOT NULL Non-Standardized Indicator

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	TEST_DT	Date(10)	DATE NOT NULL	Test Date Prompt Table: SAD_AMC_CD
3	TEST_NBR	Number(2,0)	SMALLINT NOT NULL	Test Number
4	SERIES_CD_AMCAS	Character(2)	VARCHAR2(2) NOT NULL	Series Code
5	NON_STND_IND_AMCAS	Character(1)	VARCHAR2(1) NOT NULL	Non-Standardized Indicator