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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | 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 |