HRT1783

Table Part Infotype 1783 | #masterdata | Component: United Kingdom

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (9)
☰ Categorical (7)
Other (11)
🔗 Relations (17)

Column Name	Description
MANDT FK	Client
TABNR FK	Reference Number to Table Part
TABSEQNR	Sequence Number in Table Part of Table Infotype

Column Name	Description

Column Name	Description

Column Name	Description
ENTRY_DATE	UCAS: Date of Entry
AEDTM_UCAS	UCAS: Date of the last change made by UCAS
AEDTM_INST	UCAS: Date of change made by the institution
INTERVIEW_DATE	UCAS: Date of Interview
INSTDESCDATE	Institution’s Decision Date
REFDATE	Date When Choice Was Referred
CWD_DATE_T	UCAS:CWD withraw date
RBD_DATE	UCAS: Reject by Default Date
DBD_DATE	UCAS: Decline by Default Date

Column Name	Description
CHOICE_CANCEL	UCAS:Choice cancelled by applicant	Show values
HOME_INDIC	UCAS: Live at home indicator	Show values
ADJ_STATUS	UCAS: Adjustment Status for Adjustment Choice	Show values
INTERVIEW_RESP	UCAS: Interview Response of the Applicant	Show values
DEFER_ENTRY	UCAS: Defer entry for choice details	Show values
CWD_FLAG_T	UCAS: Choice withdrew totally or re-instatement	Show values
CRIMINAL_REC_DEC	UCAS : Criminal Record Declaration	Show values

Column Name	Description	Domain name
SC_OBJID	Program ID	HROBJID
UNAME_INST	User Name	CHAR12
CAMPUS_INST	UCAS: Campus Id Changed by Institution	PIQ_GB_UCAS_CAMPUS
ENTRY_MONTH_INST	UCAS: obsolet (Entry month changed by Institution)
ENTRY_YEAR_INST	-CM UCAS: Year of Entry changed by Institution	JAHR
CONDITIONS_INST1	UCAS: Final conditions set by institution	PIQ_GB_UCAS_CONDITIONS
CONDITIONS_INST2	UCAS: Final conditions set by institution	PIQ_GB_UCAS_CONDITIONS
CONDITIONS_INST3	UCAS: Final conditions set by institution	PIQ_GB_UCAS_CONDITIONS
YR_APPLIED	Year Applied for Choice Details	PIQ_GB_UCAS_YR_APPLD
APPL_SCHEME_CODE	UCAS: Application Scheme Code	CHAR4
ROUNDNUMBER	UCAS: Round Number	NUMC3

Master Data Relations	Join Conditions
UCAS: Confirmation History	`HRT1783.MANDT == T7PIQ_GB_CON_HI.MANDT` `HRT1783.CONF_HIST == T7PIQ_GB_CON_HI.CONF_HIST`
UCAS:Confirmation status	`HRT1783.MANDT == T7PIQ_GB_STATUS.MANDT` `HRT1783.CONF_STATUS == T7PIQ_GB_STATUS.CONF_STATUS`
UCAS: Course Code UCAS: Course Code Client	`HRT1783.COURSE == T7PIQ_GB_COURSE.COURSE_ID` `HRT1783.MANDT == T7PIQ_GB_COURSE.MANDT`
UCAS: MARVIN course code institution UCAS: MARVIN course code institution Client	`HRT1783.COURSE_INST == T7PIQ_GB_COURSE.COURSE_ID` `HRT1783.MANDT == T7PIQ_GB_COURSE.MANDT`
UCAS: Decision made by the institution	`HRT1783.DECISION == T7PIQ_GB_DECIS.DECISION`
UCAS: Point of Entry	`HRT1783.MANDT == T7PIQ_GB_ENT_PN.MANDT` `HRT1783.ENTRY_POINT == T7PIQ_GB_ENT_PN.POINT_OF_ENTRY`
-CM UCAS: Point of Entry changed by Institution	`HRT1783.MANDT == T7PIQ_GB_ENT_PN.MANDT` `HRT1783.ENTRY_POINT_INST == T7PIQ_GB_ENT_PN.POINT_OF_ENTRY`
UCAS: Institution Code UCAS: Institution Code Client	`HRT1783.INSTITUTION == T7PIQ_GB_INST.INSTITUTION_ID` `HRT1783.MANDT == T7PIQ_GB_INST.MANDT`
UCAS: Priority of the interview UCAS: Priority of the interview Client	`HRT1783.INTERV_PRIO == T7PIQ_GB_INT_PRI.INTERV_PRIO` `HRT1783.MANDT == T7PIQ_GB_INT_PRI.MANDT`
Client	`HRT1783.MANDT == T000.MANDT`
UCAS: Student Offer Level	`HRT1783.MANDT == T7PIQ_GB_OFFRLEV.MANDT` `HRT1783.OFFER_LEVEL == T7PIQ_GB_OFFRLEV.OFFER_LEVEL`
Potential Offer Level	`HRT1783.MANDT == T7PIQ_GB_POTELEV.MANDT` `HRT1783.POTENTIAL_LEVEL == T7PIQ_GB_POTELEV.POTENTIAL_LEVEL`
UCAS: Reply made by applicant	`HRT1783.REPLY == T7PIQ_GB_REPLY.REPLY`
UCAS: Substitution UCAS: Substitution Client	`HRT1783.SUBSTITUTION == T7PIQ_GB_SUBSTI.SUBSTITUTION` `HRT1783.MANDT == T7PIQ_GB_SUBSTI.MANDT`
Reference Number to Table Part	`HRT1783.MANDT == HRITABNR.MANDT` `HRT1783.TABNR == HRITABNR.TABNR`
-CM UCAS: Last Transaction sent to UCAS	`HRT1783.TRANSACTION_INST == T7PIQ_GB_TRANS.UCAS_TRANSACTION`
UCAS: UCAS action	`HRT1783.MANDT == T7PIQ_GB_UCASAC.MANDT` `HRT1783.UCAS_ACTION == T7PIQ_GB_UCASAC.UCAS_ACTION`