| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | No | HRITABNR | HRTABNR | Allow NULL? |
| 3 | TABSEQNR | Sequence Number in Table Part of Table Infotype | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | HRTABSEQNR | Allow NULL? |
| 4 | EDID | Equivalency Object ID (OBSOLETE) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQEDID | Allow NULL? |
| 5 | ISSEO_SU | Issuing External Organization | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQTRISSEO | Allow NULL? |
| 6 | TRANS_GUID_SU | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PIQTRTRANS_GUID | Allow NULL? |
| 7 | TRTYPE_SU | Transcript Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PIQTRTRANSTYPE | Allow NULL? |
| 8 | COURSEID | Registered Subject | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQTRCOURSEID | Allow NULL? |
| 9 | INTGRADE | Original Grade in External Subject on Internal Grading Scale | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PIQTRINTGRADE | Allow NULL? |
| 10 | INTGRADENORM | Converted Grade per Subject (Standard Value) | decimal | 8 | 2 | DEC | ((0)) | Yes | | PIQTRINTGRADENORM | |
| 11 | INTGRADESCALE | Internal Grading Scale for Converted Grade per Subject | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PIQTRINTGRADESCALE | Allow NULL? |
| 12 | INTCOATMCRED | Attempted Credits in Ext. Subject in Internal Credit Type | decimal | 10 | 5 | QUAN | ((0)) | Yes | | PIQTRINTCOATMCRED | |
| 13 | INTCOGRDCRED | Graded Credits in Ext. Subject in Internal Credit Type | decimal | 10 | 5 | QUAN | ((0)) | Yes | | PIQTRINTCOGRDCRED | |
| 14 | INTCOERNCRED | Earned Credits in Ext. Subject in Internal Credit Type | decimal | 10 | 5 | QUAN | ((0)) | Yes | | PIQTRINTCOERNCRED | |
| 15 | INTCOCREDTYPE | Internal Credit Type | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PIQTRINTCOCREDTYPE | Allow NULL? |
| 16 | ISSEO_EQ | Issuing External Organization | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQTRISSEO | Allow NULL? |
| 17 | TRANS_GUID_EQ | GUID - Unique ID of External Transcript | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | PIQTRTRANS_GUID | Allow NULL? |
| 18 | TRTYPE_EQ | Transcript Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PIQTRTRANSTYPE | Allow NULL? |
| 19 | DEGREEID_EQ | Degree/Qualification | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQTRDEGREEID | Allow NULL? |
| 20 | DEGEXTGRADE | External Grade Achieved in Qualification | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PIQTRDEGEXTMARK | Allow NULL? |
| 21 | DEGEXTGRADENORM | External Grade of Achieved Qualification (Std Value) | decimal | 8 | 2 | DEC | ((0)) | Yes | | PIQTRDEGEXTGRADENORM | |
| 22 | DEGEXTSCALEID | Academic Scale Identification (ID) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PIQSCALE_ID | Allow NULL? |
| 23 | MODULEID | Module ID (Object Type SM) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQMODULE | Allow NULL? |
| 24 | NORM_VAL_SM | Std Value for Scale Value | decimal | 8 | 2 | DEC | ((0)) | Yes | | PIQSCALE_NORM_VAL | |
| 25 | CPATTEMP | Attempted Credits | decimal | 10 | 5 | QUAN | ((0)) | Yes | | PIQCPATTEMP | |
| 26 | CPGAINED_SM | Earned Credits | decimal | 10 | 5 | QUAN | ((0)) | Yes | | PIQCPGAINED | |
| 27 | CPUNIT_SM | Unit of Measurement for Credits | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PIQCPUNIT | Allow NULL? |
| 28 | CHARGEFREE | Free of Charge | char | 1 | 0 | CHAR | (N' ') | Yes | | PIQCHARGE | Allow NULL? |
| 29 | ALT_SCALEID | Academic Scale Identification (ID) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PIQSCALE_ID | Allow NULL? |
| 30 | SMRATING | Alternative Assessment Method for Module | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T7PIQSMRATING | PIQSMRATING | Allow NULL? |
| 31 | VARID | Session Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T7PIQVARY | PIQVARID | Allow NULL? |
| 32 | PERID | Academic Session | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | T7PIQPERIOD | PIQPERID | Allow NULL? |
| 33 | PERYR | Academic Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | T7PIQYEAR | PIQPERYR | Allow NULL? |
| 34 | DEGREEID_CQ | Degree/Qualification | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PIQTRDEGREEID | Allow NULL? |
| 35 | CPGAINED_CQ | Earned Credits | decimal | 10 | 5 | QUAN | ((0)) | Yes | | PIQCPGAINED | |
| 36 | CPUNIT_CQ | Unit of Measurement for Credits | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PIQCPUNIT | Allow NULL? |
| 37 | NORM_VAL_CQ | Std Value for Scale Value | decimal | 8 | 2 | DEC | ((0)) | Yes | | PIQSCALE_NORM_VAL | |
| 38 | CQRATING | Assessment Method for Internal Qualification | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PIQCQRATING | Allow NULL? |
