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 |