ADM_T189_XREF_S

(SQL Table)
Index Back

Applicant Xref ext sum Data

EDI TS189 record for translating Career to external summary type.

# 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 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
GRAD=Graduate
HS=High School
LAW=Law
MED=Medical
UGRD=Undergraduate
4 EXT_SUMM_TYPE Character(4) VARCHAR2(4) NOT NULL Summary Type

Prompt Table: EXT_SUMM_TP_TBL