SAP ABAP Table PIQRULEMASTER_APP (Application Data: Table)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷
IS-HER-CM-AD (Application Component) Administration
⤷
PMIQ (Package) Campus Management
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | PIQRULEMASTER_APP |
|
| Short Description | Application Data: Table |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
0 | 0 | Application: Address Data | |||||
| 2 | |
SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * | |
| 3 | |
HAUSN_BAS | CHAR6 | CHAR | 6 | 0 | House number | ||
| 4 | |
PD_STRAS | TEXT30 | CHAR | 30 | 0 | House Number and Street | ||
| 5 | |
STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
| 6 | |
KORT | TEXT40 | CHAR | 40 | 0 | City | ||
| 7 | |
PD_PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
| 8 | |
KLAND | LAND1 | CHAR | 3 | 0 | Country | T005 | |
| 9 | |
REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
| 10 | |
TELENR | CHAR25 | CHAR | 25 | 0 | Telephone Number | ||
| 11 | |
FAXNR | CHAR25 | CHAR | 25 | 0 | Fax Number | ||
| 12 | |
0 | 0 | Application: Academic Specializations | |||||
| 13 | |
PIQCGOBJID | HROBJID | NUMC | 8 | 0 | Module Group ID | * | |
| 14 | |
0 | 0 | Transcripts (Header Data) | |||||
| 15 | |
PIQTRTRANS_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID - Unique ID of External Transcript | ||
| 16 | |
PIQTRTRANSTYPE | PIQTRTRANSTYPE | CHAR | 4 | 0 | Transcript Category | * | |
| 17 | |
PIQTRISSEO | HROBJID | NUMC | 8 | 0 | Issuing External Organization | * | |
| 18 | |
PIQTRTRANSEO | HROBJID | NUMC | 8 | 0 | Transmitting External Organization | * | |
| 19 | |
PIQREPSTATE | PIQREPSTATE | CHAR | 4 | 0 | Transcript Status | T7PIQREPSTAT | |
| 20 | |
PIQTRREGPERIODFROM | DATS | 8 | 0 | Start Date of Registration at External Organization | |||
| 21 | |
PIQTRREGPERIODTO | DATS | 8 | 0 | End Date of Registration at External Organization | |||
| 22 | |
PIQTRRANKING | NUMC | 4 | 0 | Rank | |||
| 23 | |
PIQTRSIZEOFCLASS | NUMC | 4 | 0 | Class Size | |||
| 24 | |
PIQTRRETURNINDIC | PIQTRRETURNINDIC | CHAR | 4 | 0 | Eligibility to Return | T7PIQTRRETINDIC | |
| 25 | |
PIQTRRETURNDATE | DATS | 8 | 0 | Date of Eligibility to Return | |||
| 26 | |
PIQTRTOTSELFREPGPA | CHAR | 10 | 0 | Self-Reported Average | |||
| 27 | |
PIQTRTOTSELFGPANORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Self-Reported Average (Standard Value) | ||
| 28 | |
PIQTRTOTSELFGPASCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Self-Reported Average | T7PIQSCALE | |
| 29 | |
PIQTRTOTEXTGPA1 | CHAR | 10 | 0 | External Average 1 | |||
| 30 | |
PIQTRTOTEXTGPA1NORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | External Average 1 (Standard Value) | ||
| 31 | |
PIQTRTOTEXTGPA1SCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for External Average 1 | T7PIQSCALE | |
| 32 | |
PIQTRTOTEXTGPA2 | CHAR | 10 | 0 | External Average 2 | |||
| 33 | |
PIQTRTOTEXTGPA2NORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | External Average 2 (Standard Value) | ||
| 34 | |
PIQTRTOTEXTGPA2SCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for External Average 2 | T7PIQSCALE | |
| 35 | |
PIQTRTOTEXTGPA3 | CHAR | 10 | 0 | External Average 3 | |||
| 36 | |
PIQTRTOTEXTGPA3NORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | External Average 3 (Standard Value) | ||
| 37 | |
PIQTRTOTEXTGPA3SCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for External Average 3 | T7PIQSCALE | |
| 38 | |
PIQTRCALCGPAMANFLAG | CHAR | 1 | 0 | Overwrite Calculated Average Manually | |||
| 39 | |
PIQTRTOTCALCGPA | CHAR | 10 | 0 | Calculated Average | |||
| 40 | |
PIQTRTOTCALCGPANORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Calculated Average (Standard Value) | ||
| 41 | |
PIQTRTOTCALCGPASCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Calculated Average | T7PIQSCALE | |
| 42 | |
PIQTRTOTEXTATMCRED | PIQCP | QUAN | 10 | 5 | Total Attempted Credits | ||
| 43 | |
PIQTRTOTEXTGRDCRED | PIQCP | QUAN | 10 | 5 | Total Graded Credits | ||
| 44 | |
PIQTRTOTEXTERNCRED | PIQCP | QUAN | 10 | 5 | Total Earned Credits | ||
| 45 | |
PIQTRTOTEXTCREDTYPE | MEINS | UNIT | 3 | 0 | Original Type of Total Credits | T7PIQCP | |
| 46 | |
PIQTRTOTCREDMANFLAG | CHAR | 1 | 0 | Overwrite Converted Credits Manually | |||
| 47 | |
PIQTRTOTINTATMCRED | PIQCP | QUAN | 10 | 5 | Total Attempted Credits In Internal Credit Type | ||
| 48 | |
PIQTRTOTINTGRDCRED | PIQCP | QUAN | 10 | 5 | Total Graded Credits In Internal Credit Type | ||
| 49 | |
PIQTRTOTINTERNCRED | PIQCP | QUAN | 10 | 5 | Total Earned Credits In Internal Credit Type | ||
| 50 | |
PIQTRTOTINTCREDTYPE | MEINS | UNIT | 3 | 0 | Converted Credit Type | T7PIQCP | |
| 51 | |
0 | 0 | External Academic Qualifications | |||||
| 52 | |
PIQTRDEGREENR | NUMC | 2 | 0 | Number of Degree/Qualification | |||
| 53 | |
PIQTRDEGREEID | HROBJID | NUMC | 8 | 0 | Degree/Qualification | * | |
| 54 | |
PIQTRPROGRAMID | CHAR | 12 | 0 | Registered Program | |||
| 55 | |
PIQTRDEGERNFLAG | PIQTRDEGERNFLAG | CHAR | 1 | 0 | Indicator: Degree or Qualification Earned | ||
| 56 | |
PIQTRDEGDATE | DATS | 8 | 0 | (Anticipated) Completion Date | |||
| 57 | |
PIQTRDEGEXTMARK | CHAR | 10 | 0 | External Grade Achieved in Qualification | |||
| 58 | |
PIQTRDEGEXTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | External Grade of Achieved Qualification (Std Value) | ||
| 59 | |
PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
| 60 | |
PIQTRDEGMANFLAG | CHAR | 1 | 0 | Overwrite Internal Grade of Qualification Manually | |||
| 61 | |
PIQTRDEGINTGRADE | CHAR | 10 | 0 | Internal Grade of Achieved Qualification | |||
| 62 | |
PIQTRDEGINTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Internal Grade of Achieved Qualification (Std Value) | ||
| 63 | |
PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
| 64 | |
PIQTRDEGHONORS | PIQTRDEGHONORS | CHAR | 4 | 0 | Academic Honors in Qualification | T7PIQTRDEGHON | |
| 65 | |
0 | 0 | External Academic Specializations | |||||
| 66 | |
PIQTRDEGREENR | NUMC | 2 | 0 | Number of Degree/Qualification | |||
| 67 | |
PIQTRDEGSPECID | PIQSMDISZIP | CHAR | 16 | 0 | Chosen Program Specialization | T7PIQSMDISZIP | |
| 68 | |
PIQTRDEGSPECTYPE | PIQMODGRPCAT | CHAR | 4 | 0 | Specialization Type | T7PIQMODGRPCAT | |
| 69 | |
0 | 0 | Academic Session Data of External Organization | |||||
| 70 | |
PIQTRSESSIONID | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session | T7PIQTREXTSES | |
| 71 | |
PIQTRSESSIONYEAR | PIQTRSESSIONYEAR | NUMC | 4 | 0 | Year of Registration | ||
| 72 | |
PIQTRSESBEGDATE | DATS | 8 | 0 | Start Date of Academic Session | |||
| 73 | |
PIQTRSESENDDATE | DATS | 8 | 0 | End Date of Academic Session | |||
| 74 | |
PIQTRSESWITHDRDATE | DATS | 8 | 0 | De-registration Date | |||
| 75 | |
PIQTRDEGREEID | HROBJID | NUMC | 8 | 0 | Degree/Qualification | * | |
| 76 | |
PIQTRPROGRAMID | CHAR | 12 | 0 | Registered Program | |||
| 77 | |
PIQTRSTAGEID | PIQLEVEL | NUMC | 2 | 0 | Registered Program Stage | T7PIQLEVEL | |
| 78 | |
PIQTRPROGCLASSID | PIQPROGCLASS | CHAR | 4 | 0 | Progress Classification | T7PIQPROGCLASS | |
| 79 | |
PIQTRPROGACST | PIQTRPROGACST | CHAR | 4 | 0 | External Academic Standing | T7PIQTRPROGAS | |
| 80 | |
PIQPROGSTATUS | PIQPROGSTATUS | NUMC | 3 | 0 | Program Progression Status | T7PIQPROGSTATUS | |
| 81 | |
PIQTREXTSESGPA | CHAR | 10 | 0 | External Sessional Average | |||
| 82 | |
PIQTREXTSESGPANORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Original Sessional Average Standard Value) | ||
| 83 | |
PIQTREXTSESGPASCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Original Sessional Average | T7PIQSCALE | |
| 84 | |
TRPIQSESGPAMANFLAG | CHAR | 1 | 0 | Overwrite Internal Sessional Average Manually | |||
| 85 | |
PIQTRINTSESGPA | CHAR | 10 | 0 | Internal Sessional Average | |||
| 86 | |
PIQTRINTSESGPANORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Internal Sessional Average (Standard Value) | ||
| 87 | |
PIQTRINTSESGPASCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Internal Sessional Average | T7PIQSCALE | |
| 88 | |
PIQTREXTSESATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits Per Academic Session | ||
| 89 | |
PIQTREXTSESGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits Per Academic Session | ||
| 90 | |
PIQTREXTSESERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits Per Academic Session | ||
| 91 | |
PIQTREXTSESCREDTYPE | MEINS | UNIT | 3 | 0 | External Credit Type of Sessional Credits | T7PIQCP | |
| 92 | |
PIQTRSESCREDMANFLAG | CHAR | 1 | 0 | Overwrite Converted Sessional Credits Manually | |||
| 93 | |
PIQTRINTSESATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits Per Session In Internal Credit Type | ||
| 94 | |
PIQTRINTSESGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits Per Session In Internal Credit Type | ||
| 95 | |
PIQTRINTSESERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits Per Session In Internal Credit Type | ||
| 96 | |
PIQTRINTSESCREDTYPE | MEINS | UNIT | 3 | 0 | Credit Type of Converted Sessional Credits | T7PIQCP | |
| 97 | |
0 | 0 | External Subject Data | |||||
| 98 | |
PIQTRCOURSEID | HROBJID | NUMC | 8 | 0 | Registered Subject | * | |
| 99 | |
PIQTREXTGRADE | CHAR | 10 | 0 | Original Grade in External Subject | |||
| 100 | |
PIQTREXTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Original Grade per Subject (Standard Value) | ||
| 101 | |
PIQTREXTGRADESCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for Original Grade | T7PIQSCALE | |
| 102 | |
PIQTRGRADEMANFLAG | CHAR | 1 | 0 | Overwrite Converted Original Grade of External Subject | |||
| 103 | |
PIQTRINTGRADE | CHAR | 10 | 0 | Original Grade in External Subject on Internal Grading Scale | |||
| 104 | |
PIQTRINTGRADENORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Converted Grade per Subject (Standard Value) | ||
| 105 | |
PIQTRINTGRADESCALE | PIQSCALE_ID | CHAR | 4 | 0 | Internal Grading Scale for Converted Grade per Subject | T7PIQSCALE | |
| 106 | |
PIQTRCOREPEATFLAG | CHAR | 1 | 0 | Indicator: Repeated Subject | |||
| 107 | |
PIQTRHONORSINDIC | CHAR | 1 | 0 | Indicator: Honors Subject | |||
| 108 | |
PIQTREXTCOATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits in External Subject | ||
| 109 | |
PIQTREXTCOGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits in External Subject | ||
| 110 | |
PIQTREXTCOERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits in External Subject | ||
| 111 | |
PIQTREXTCOCREDTYPE | MEINS | UNIT | 3 | 0 | Original Credit Type of External Subject | T7PIQCP | |
| 112 | |
PIQTRCOCREDMANFLAG | CHAR | 1 | 0 | Overwrite Converted Credits Per External Subject Manually | |||
| 113 | |
PIQTRINTCOATMCRED | PIQCP | QUAN | 10 | 5 | Attempted Credits in Ext. Subject in Internal Credit Type | ||
| 114 | |
PIQTRINTCOGRDCRED | PIQCP | QUAN | 10 | 5 | Graded Credits in Ext. Subject in Internal Credit Type | ||
| 115 | |
PIQTRINTCOERNCRED | PIQCP | QUAN | 10 | 5 | Earned Credits in Ext. Subject in Internal Credit Type | ||
| 116 | |
PIQTRINTCOCREDTYPE | MEINS | UNIT | 3 | 0 | Internal Credit Type | T7PIQCP | |
| 117 | |
PIQTRBASFORCOCRED | PIQTRBASFORCRED | CHAR | 4 | 0 | Basis for Accomplished Credits | T7PIQTRBASFORCP | |
| 118 | |
PIQTRCOREFLAG | CHAR | 1 | 0 | Indicator for Core Subject | |||
| 119 | |
PIQTRCOWITHDRDATE | DATS | 8 | 0 | Date of Withdrawal | |||
| 120 | |
PIQTRCOSESID | PIQTRSESSIONID | CHAR | 4 | 0 | Session In Which External Subject Was Taken | T7PIQTREXTSES | |
| 121 | |
PIQTRCOSESYEAR | PIQTRSESSIONYEAR | NUMC | 4 | 0 | Year In Which Subject Was Taken | ||
| 122 | |
PIQTRCOBEGDATE | DATS | 8 | 0 | Start Date of Subject | |||
| 123 | |
PIQTRCOENDDATE | DATS | 8 | 0 | End Date of Subject | |||
| 124 | |
0 | 0 | Coded Notes | |||||
| 125 | |
PIQTRCODEDNOTEID | PIQTRCODEDNOTEID | CHAR | 12 | 0 | Coded Note | T7PIQTRCODNOTE | |
| 126 | |
PIQTRCOMMENT | TEXT80 | CHAR | 80 | 0 | Comment | ||
| 127 | |
0 | 0 | External Test Results (Header Data) | |||||
| 128 | |
PIQTRTEST_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID - Unique ID of External Test Results | ||
| 129 | |
PIQTRISSEO | HROBJID | NUMC | 8 | 0 | Issuing External Organization | * | |
| 130 | |
PIQTRTRANSEO | HROBJID | NUMC | 8 | 0 | Transmitting External Organization | * | |
| 131 | |
PIQTRTESTTYPE | PIQTRTESTTYPE | CHAR | 12 | 0 | Test Type | T7PIQTRTESTTYPE | |
| 132 | |
PIQTRSESSIONID | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session | T7PIQTREXTSES | |
| 133 | |
PIQTRSESSIONYEAR | PIQTRSESSIONYEAR | NUMC | 4 | 0 | Year of Registration | ||
| 134 | |
PIQTRENTRYDATE | DATS | 8 | 0 | Entry Date of External Test Results | |||
| 135 | |
PIQTRTESTPASSFAIL | PIQTRTESTPASSFAIL | CHAR | 1 | 0 | External Test Passed | ||
| 136 | |
PIQTREXTTOTRES | CHAR | 10 | 0 | Total Test Result | |||
| 137 | |
PIQTREXTTOTRESNORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Total Test Result (Standard Value) | ||
| 138 | |
PIQTRTESTSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for External Average | T7PIQSCALE | |
| 139 | |
PIQTRTOTALPERCENT | PIQTRTOTALPERCENT | DEC | 5 | 2 | Student's Percentile Rank | ||
| 140 | |
PIQTRTOTALPERCENT2 | PIQTRTOTALPERCENT | DEC | 5 | 2 | Additional Total Test Percentile | ||
| 141 | |
PIQTRENTRYMODE | PIQTRENTRYMODE | CHAR | 4 | 0 | Source of External Test Results | T7PIQTRENTRYMOD | |
| 142 | |
PIQTRTESTRESULTSTATUS | PIQTRTESTRESULTSTATUS | CHAR | 3 | 0 | External Test Result Status | T7PIQTRSTAT | |
| 143 | |
PIQTRINVALIDATEREASON | PIQTRINVALIDATESCOREREASON | CHAR | 3 | 0 | Reason for invalidating the Test Result | T7PIQINVRSN | |
| 144 | |
0 | 0 | External Subtest Results | |||||
| 145 | |
PIQTRSUBTESTID | PIQTRSUBTESTID | CHAR | 12 | 0 | Subtest | T7PIQTRSUBTEST | |
| 146 | |
PIQTREXTSUBRES | CHAR | 10 | 0 | Result of External Subtest | |||
| 147 | |
PIQTREXTSUBRESNORM | PIQSCALE_NORM_VAL | DEC | 8 | 2 | External Subtest Result (Standard Value) | ||
| 148 | |
PIQTREXTSUBRESSCALE | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for External Subtest Result | * | |
| 149 | |
PIQTRSUBPERCENT | PIQTRTOTALPERCENT | DEC | 5 | 2 | Student's Subtest Percentile Rank | ||
| 150 | |
PIQTRSUBPERCENT2 | PIQTRTOTALPERCENT | DEC | 5 | 2 | Additional Subtest Percentile | ||
| 151 | |
0 | 0 |
Foreign Keys
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in | 463 |