SAD_AMC_SUS(SQL Table) |
Index Back |
|---|---|
AMCAS Suspension TableAMCAS_SUSPN contains all records from the AMCAS load process. AMCAS edit will update fields. Those records which are 'clean' will be processed by the AMCAS post program, loaded into the 'live' tables and then removed from the suspense table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SA_TEST_TBL |
| 2 | TEST_REC_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | Test Type Record Nbr |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 4 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 5 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 6 | SAD_AMC_ALT_ID | Character(9) | VARCHAR2(9) NOT NULL | AMCAS Aternate ID |
| 7 | AMCAS_FILNBR_AMCAS | Character(10) | VARCHAR2(10) NOT NULL | AMCAS File Number |
| 8 | ADMIT_TERM_AMCAS | Character(4) | VARCHAR2(4) NOT NULL | AMCAS Application Year |
| 9 | EVALUATION_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | Evaluation |
| 10 | NOTFICTN_PLN_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | AMCAS Early Decision Applicant |
| 11 | APPL_FEE_ST_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | AMCAS Application Fee Waiver |
| 12 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 13 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 14 | SAD_MID_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 15 | SAD_MID_INIT_LD | Character(1) | VARCHAR2(1) NOT NULL | Admissions Middle Initial from Test Load |
| 16 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 17 | SUFFIX_AMCAS | Character(3) | VARCHAR2(3) NOT NULL | Suffix |
| 18 | SAD_AMC_LST_NM_OLD | Character(16) | VARCHAR2(16) NOT NULL | Old Last Name |
| 19 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 20 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 21 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 22 | SAD_TELEPHONE_LD | Character(20) | VARCHAR2(20) NOT NULL | Telephone Number |
| 23 | STATE_RES_AMCAS | Character(2) | VARCHAR2(2) NOT NULL | AMCAS State of Residence |
| 24 | CNTY_CD_RES_AMCAS | Character(3) | VARCHAR2(3) NOT NULL | AMCAS Residency County Code |
| 25 | COUNTY_AMCAS | Character(20) | VARCHAR2(20) NOT NULL | AMCAS County of Residence |
| 26 | CNTY_RU_IND_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | AMCAS County Rural Indicator |
| 27 | SAD_COUNTRY_LD | Character(30) | VARCHAR2(30) NOT NULL | Test Load Country |
| 28 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 29 | COUNTRY_AMCAS | Character(20) | VARCHAR2(20) NOT NULL | AMCAS Country |
| 30 | VISA_PERMIT_AMCAS | Character(2) | VARCHAR2(2) NOT NULL | Visa Permit Type |
| 31 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 32 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 33 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 34 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 35 | BIRTH_STATE_AMCAS | Character(6) | VARCHAR2(6) NOT NULL | AMCAS Birth State |
| 36 | BIRTH_CITY_AMCAS | Character(15) | VARCHAR2(15) NOT NULL | AMCAS Birth City |
| 37 | BRTH_CNTRYCD_AMCAS | Character(3) | VARCHAR2(3) NOT NULL | AMCAS Birth Country Code |
| 38 | BIRTH_CNTRY_AMCAS | Character(20) | VARCHAR2(20) NOT NULL | AMCAS Birth Country |
| 39 | BIR_RUR_IND_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | AMCAS Birth County Rural Indicator |
| 40 | AGE_AMCAS | Number(2,0) | SMALLINT NOT NULL | Age |
| 41 | NBR_OF_DEPND_AMCAS | Number(2,0) | SMALLINT NOT NULL | Number of Dependents |
| 42 | SAD_ETHNICITY_LD | Character(2) | VARCHAR2(2) NOT NULL | Ethnicity |
| 43 | ETHNIC_GRP_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table:
ETHNIC_GRP_TBL
|
| 44 | MRTY_APL_RSN_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | AMCAS Minority Applicant |
| 45 | MILITARY_ST_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | AMCAS Military Service |
| 46 | CBC_MILITARY_DISCH | Character(1) | VARCHAR2(1) NOT NULL | Military Discharge |
| 47 | CBC_MILITARY_HON | Character(1) | VARCHAR2(1) NOT NULL | Honorable Discharge |
| 48 | MATRICULATED_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | Previous Matriculation |
| 49 | RCPNT_ACTION_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | Recipient of Any Action |
| 50 | FELONY_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | Felony |
| 51 | CBC_FELONY_IND | Character(1) | VARCHAR2(1) NOT NULL | CBC Felony |
| 52 | CBC_MISDEMEANOR | Character(1) | VARCHAR2(1) NOT NULL | CBC Misdemeanor |
| 53 | PLUS_MNS_GRD_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | Plus or Minus Grade |
| 54 | NBR_MCT_TKN_MCAT | Character(3) | VARCHAR2(3) NOT NULL | Number of MCATs Taken |
| 55 | NEXT_TEST_DT_MCAT | Character(6) | VARCHAR2(6) NOT NULL | Next MCAT Test Date |
| 56 | ADDL_MCAT_INTENT | Character(1) | VARCHAR2(1) NOT NULL | Addl MCAT Intent |
| 57 | ADDL_MCAT_INT_DT | Character(12) | VARCHAR2(12) NOT NULL | Addl MCAT Intent Date |
| 58 | SAD_TEST_DT_LD | Character(10) | VARCHAR2(10) NOT NULL | Test Load Test Date |
| 59 | SCHL_STATE_AMCAS | Character(2) | VARCHAR2(2) NOT NULL | School State |
| 60 | SCHOOL_NBR_AMCAS | Character(3) | VARCHAR2(3) NOT NULL | AMCAS School Number |
| 61 | APPL_DATE_AMCAS | Character(8) | VARCHAR2(8) NOT NULL | AMCAS Date of Application |
| 62 | YR_APPL1_AMCAS | Character(4) | VARCHAR2(4) NOT NULL | AMCAS Year Previously Applied 1 |
| 63 | YR_APPL2_AMCAS | Character(4) | VARCHAR2(4) NOT NULL | AMCAS Year Previously Applied 2 |
| 64 | YR_APPL3_AMCAS | Character(4) | VARCHAR2(4) NOT NULL | AMCAS Year Previously Applied 3 |
| 65 | YR_APPL4_AMCAS | Character(4) | VARCHAR2(4) NOT NULL | AMCAS Year Previously Applied 4 |
| 66 | ADM_ACTN_CD_AMCAS | Character(2) | VARCHAR2(2) NOT NULL | Admission Action Code |
| 67 | ACTION_DT_AMCAS | Character(8) | VARCHAR2(8) NOT NULL | Action Date |
| 68 | MATRICULA_DT_AMCAS | Character(6) | VARCHAR2(6) NOT NULL | Matriculation Date |
| 69 | EXPCT_GRD_DT_AMCAS | Character(6) | VARCHAR2(6) NOT NULL | Expected Graduation Date |
| 70 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 71 | VERIFIED_IND | Character(1) | VARCHAR2(1) NOT NULL | Verified Indicator |
| 72 | EFFDT_AMCAS | Character(8) | VARCHAR2(8) NOT NULL | Effective Date |
| 73 | APPL_TYPE_AMCAS | Character(1) | VARCHAR2(1) NOT NULL | Application Type |
| 74 | BIO_NBR_AMCAS | Character(22) | VARCHAR2(22) NOT NULL | Bio Number |
| 75 | ETHNICHISP_IND | Character(1) | VARCHAR2(1) NOT NULL | Ethnic Hispanic Indicator |
| 76 | PREF_CNTRY_CD_AMCS | Character(3) | VARCHAR2(3) NOT NULL | Preferred Country Code |
| 77 | URM_IND | Character(1) | VARCHAR2(1) NOT NULL | URM Indicator |
| 78 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 79 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 80 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 81 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table: ADM_USA_CIT_VW |