SAP ABAP Table PIQTRTESTRESULTS_EXT (External Test Results (Header Data))
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
Basic Data
Table Category | INTTAB | Structure |
Structure | PIQTRTESTRESULTS_EXT | Table Relationship Diagram |
Short Description | External Test Results (Header Data) |
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 | ISSUEDATE | PIQTRTESTISSUEDATE | DATUM | DATS | 8 | 0 | Test Date | ||
2 | VALIDDATE | PIQTRVALIDDATE | DATUM | DATS | 8 | 0 | Validity Date of Test | ||
3 | TEST_GUID | PIQTRTEST_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID - Unique ID of External Test Results | ||
4 | TESTEO | PIQTRISSEO | HROBJID | NUMC | 8 | 0 | Issuing External Organization | * | |
5 | TRANSEO | PIQTRTRANSEO | HROBJID | NUMC | 8 | 0 | Transmitting External Organization | * | |
6 | TESTTYPE | PIQTRTESTTYPE | PIQTRTESTTYPE | CHAR | 12 | 0 | Test Type | T7PIQTRTESTTYPE | |
7 | SESSIONID | PIQTRSESSIONID | PIQTRSESSIONID | CHAR | 4 | 0 | External Academic Session | T7PIQTREXTSES | |
8 | SESSIONYEAR | PIQTRSESSIONYEAR | PIQTRSESSIONYEAR | NUMC | 4 | 0 | Year of Registration | ||
9 | ENTRYDATE | PIQTRENTRYDATE | DATS | 8 | 0 | Entry Date of External Test Results | |||
10 | TESTPASSFAIL | PIQTRTESTPASSFAIL | PIQTRTESTPASSFAIL | CHAR | 1 | 0 | External Test Passed | ||
11 | TESTTOTRES | PIQTREXTTOTRES | CHAR | 10 | 0 | Total Test Result | |||
12 | TESTSCALE_ID | PIQTRTESTSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Grading Scale for External Average | T7PIQSCALE | |
13 | TOTALPERCENT1 | PIQTRTOTALPERCENT | PIQTRTOTALPERCENT | DEC | 5 | 2 | Student's Percentile Rank | ||
14 | TOTALPERCENT2 | PIQTRTOTALPERCENT2 | PIQTRTOTALPERCENT | DEC | 5 | 2 | Additional Total Test Percentile | ||
15 | ENTRYMODE | PIQTRENTRYMODE | PIQTRENTRYMODE | CHAR | 4 | 0 | Source of External Test Results | T7PIQTRENTRYMOD | |
16 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PIQTRTESTRESULTS_EXT | ENTRYMODE | T7PIQTRENTRYMOD | ENTRYMODE | 1 | CN | |
2 | PIQTRTESTRESULTS_EXT | SESSIONID | T7PIQTREXTSES | SESSIONID | 1 | CN | |
3 | PIQTRTESTRESULTS_EXT | TESTSCALE_ID | T7PIQSCALE | SCALEID | 1 | CN | |
4 | PIQTRTESTRESULTS_EXT | TESTTYPE | T7PIQTRTESTTYPE | TESTTYPE | 1 | CN |
History
Last changed by/on | SAP | 20091125 |
SAP Release Created in | 463 |