PMIQ_US_STORDATA

1098T: Store Student’s form data | #masterdata | Component: USA
Column Name Description
MANDT Client
GPART FK Business Partner Number
GJAHR 1098T: Reporting Year
US_FILE_CORR_IND Checkbox Show values
VERSION Student record version
Column Name Description
💲 Currency Key (WAERS):
BETRH Amount In Local Currency With +/- Signs
BETRW Amount in Transaction Currency with +/- Sign
AMNT_BOX1 1098T: Qualified Paid fee for This Year
AMNT_BOX2 1098T: Tuition Fee for This Year
AMNT_BOX3 1098T: Adjustment for Tuition Fee for Previous Year
AMNT_BOX4 1098T: Grants for This Year
AMNT_BOX5 1098T: Adjustment for Grants for Previous Year
AMT_QTRE 1098T: Qualified billed fee for This Year
AMT_PYMTS 1098T: Qualified Paid fee for This Year
AMT_CF_QTRE 1098T: Carried Forward Billed fees for This Year
AMT_CF_CREDITS 1098T: Carry Forward Payment Credits
ACC_BALANCE 1098T: Carry Forward Payment Credits
AMT_CF_NQTRE 1098T: Carry Forward Payment Credits
Column Name Description
Column Name Description
RECORD_DATE null
Column Name Description
US_FILE_CORR_IND Checkbox Show values
VALID_SSN 1098T: SSN ID validation Show values
BOX6 1098t: Include Amounts Relating to Next Year Show values
HALF_TIME Training Time for Courses Show values
GRADUATE Type of Training Show values
US_FILE_TAPE Checkbox Show values
CHECK_BOX_3 Checkbox Show values
Column Name Description Domain name
STUD_NO Student Number PIQSTUDENT12
GRANT_NBR Grant GM_GRANT_NBR
SSN 1098T: Social Security Number CHAR20
STUD_NAME1 Last Name PAD_NACHN
STUD_NAME2 First Name PAD_VORNM
STUD_NAME3 Middle Name PAD_VORNM
STUD_HOUSE House number TEXT10
STUD_PFACH PO Box PFACH
STUD_CITY City TEXT35
STUD_REGIO Region (State, Province, County) REGIO
STUD_STREET Street TEXT30
STUD_PSTL2 P.O. Box Postal Code PSTLZ
US_TRANS_NAME1 Name TEXT30
US_TRANS_NAME2 Name TEXT30
STUD_LAND1 Country/Region Key LAND1
FILERS_NAME 1098T: Filer's Name 1 TEXT30
FILERS_NAME2 1098T: Filer's Name 2 TEXT30
US_COMP_STRAS Street and House Number TEXT35
US_COMP_CITY City TEXT25
US_COMP_STATE Region (State, Province, County) REGIO
FILERS_TELE 1098T: Filer's Telephone Number CHAR12
FID_NO 1098T: Federal Identification Number PIQ_US_FID
ACCT_NO 1098T: Service Provider/Acct_No PIQSTUDENT12
US_COMP_NAME1 Name TEXT30
US_COMP_NAME2 Name 2 TEXT30
US_CONTACT_PERS Name TEXT30
US_CONTACT_TELNO Phone Number of Employee Group Responsible for Company Area CHAR12
US_CONTACT_EMAIL E-mail address CHAR35
US_IRS_FNAME IRS File Name CHAR15
PSGRANT Grant PSGRANT_PS
STU_FNAME 1098T Report Full name TEXT60
STU_STRADD 1098T Student street Details TEXT60
STU_RMADD 1098T city State and Zip Code TEXT60
FIL_FNAME 1098T Report Full name TEXT60
FIL_RMADD 1098T city State and Zip Code TEXT60
US_PAYEENAME1 1098T: Payee Name1 CHAR40
US_PAYEENAME2 1098T : Payeename 2 CHAR40
RECORD_BY null
Master Data Relations Join Conditions
Business partner
  • Business Partner Number
  • Client
  • PMIQ_US_STORDATA.GPART == BUT000.PARTNER
  • PMIQ_US_STORDATA.MANDT == BUT000.CLIENT