ADM_T189_PARMS(SQL Table) | 
Index Back | 
|---|---|
ADM T189 Applicant ParametersHolds parameters to run TS189 Application. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
| 3 | POST_REC_SELECTION | Character(1) | VARCHAR2(1) NOT NULL | 
Process Single Record
 Y/N Table Edit Default Value: N  | 
| 4 | TRANS_CNTRL_NBR | Character(9) | VARCHAR2(9) NOT NULL | 
Transaction Set Control Number
 Prompt Table: %EDITTABLE  | 
| 5 | PURGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL | 
Purge Option
 A=All Suspense Rows M=Marked Suspense Rows Default Value: M  | 
| 6 | PURGE_MSGS_OPTION | Character(1) | VARCHAR2(1) NOT NULL | 
Purge Messages
 A=All Messages M=Remove Associated Messages N=Retain Associated Messages Default Value: N  | 
| 7 | NAME_PREFIX_M | Character(4) | VARCHAR2(4) NOT NULL | 
Male Name Prefix
 Prompt Table: NAME_PREFIX_TBL  | 
| 8 | NAME_PREFIX_F | Character(4) | VARCHAR2(4) NOT NULL | 
Female Name Prefix
 Prompt Table: NAME_PREFIX_TBL  | 
| 9 | NAME_PREFIX_U | Character(4) | VARCHAR2(4) NOT NULL | 
Unknown Name Prefix
 Prompt Table: NAME_PREFIX_TBL  | 
| 10 | LS_DATA_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | 
Data Source
 A8=TEAS Degree Information AAD=AADSAS ACT=American College Testing AE=Ad-Hoc Employee AMC=AMCAS AO=Ad-Hoc Organizational E=Extract ETS=Educational Testing Service GH=OLSAS Last Secondary-G2 LSD=LSDAS PI=Prev/Post Secondary Info RS=OLSAS Postsecondary Info SCH=School SLF=Self-Reported Information WWW=World Wide Web Default Value: SCH  | 
| 11 | SRCH_MTCH_PST_OPTN | Character(1) | VARCHAR2(1) NOT NULL | 
Search/Match/Post Process Optn
 B=Search, Match and Post P=Post Only S=Search and Match Only Default Value: B  | 
| 12 | LS_CONTACT_TYPE | Character(3) | VARCHAR2(3) NOT NULL | 
Contact Type
 Prompt Table: ORG_CNT_TYP_TBL  | 
| 13 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | 
Regulatory Region
 Prompt Table: REG_REGION_TBL  | 
| 14 | SAD_UPD_ETH_VER | Character(1) | VARCHAR2(1) NOT NULL | 
Update IPEDS Ethnicity Flag
 A=For All Person Records Posted N=For New Person Records Added Default Value: N  |