SAP ABAP Table PIQAGR_APPRDATA_DLG (Academic Work)
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 | PIQAGR_APPRDATA_DLG | Table Relationship Diagram |
Short Description | Academic Work |
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 | .INCLUDE | 0 | 0 | Appraisal | |||||
2 | AGRID | PIQAGRID | SYSUUID_C | CHAR | 32 | 0 | Appraisal ID | ||
3 | .INCLUDE | 0 | 0 | Appraisal: Administration Data | |||||
4 | ATTNO | PIQAGR_ATTNO | NUM03 | NUMC | 3 | 0 | Repetition Attempt Number | ||
5 | AGRTYPE | PIQAGRTYPE | PIQAGRTYPE | NUMC | 4 | 0 | Appraisal Type | * | |
6 | AGRSTAT | PIQAGRSTAT | PIQAGRSTAT | CHAR | 5 | 0 | Appraisal Status | * | |
7 | ARCH_STATUS | PIQAGR_ARCH_STATUS | PIQAGR_ARCH_STATUS | CHAR | 1 | 0 | Appraisal Archiving Status | ||
8 | AGRREMARK | PIQAGRREMARK | PIQAGRREMARK | CHAR | 2 | 0 | Appraisal Remark | * | |
9 | AYEAR | PIQPERYR | PIQPERYR | NUMC | 4 | 0 | Academic Year | T7PIQYEAR | |
10 | APERIOD | PIQPERID | PIQPERID | NUMC | 3 | 0 | Academic Session | T7PIQPERIOD | |
11 | .INCLUDE | 0 | 0 | Appraisal Validity | |||||
12 | AGRBEGDA | PIQAGRBEGDA | PIQDATE | DATS | 8 | 0 | Start of Appraisal Validity | ||
13 | AGRENDDA | PIQAGRENDDA | PIQDATE | DATS | 8 | 0 | End of Appraisal Validity | ||
14 | AGRDATEE | PIQAGRDATEE | PIQDATE | DATS | 8 | 0 | Earliest Appraisal Date | ||
15 | AGRDATEL | PIQAGRDATEL | PIQDATE | DATS | 8 | 0 | Latest Appraisal Date | ||
16 | .INCLUDE | 0 | 0 | Appraisal Relationship Information | |||||
17 | AGRWEIGHT | PIQAGRWEIGHT | PIQAGRWEIGHT | DEC | 5 | 2 | Appraisal Weighting | ||
18 | UPAGRID | PIQAGRID | SYSUUID_C | CHAR | 32 | 0 | Appraisal ID | PIQDBAGR_GEN | |
19 | .INCLUDE | 0 | 0 | Grading Information | |||||
20 | GRADESYM | PIQGRADESYM | PIQGRADESYM | CHAR | 10 | 0 | Grade Symbol | ||
21 | GRADE | PIQSCALE_NORM_VAL | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Std Value for Scale Value | ||
22 | GRADESCALE | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | * | |
23 | AGRNOTRATED | PIQAGRNOTRATED | PIQAGRNOTRATED | CHAR | 1 | 0 | Appraisal Grade Not Relevant | ||
24 | AGRDATE | PIQAGRDATE | PIQDATE | DATS | 8 | 0 | Appraisal Date | ||
25 | AGRCOMPLETED | PIQAGRCOMPLETED | PIQAGRCOMPLETED | CHAR | 1 | 0 | Appraisal Completed | ||
26 | NOTEID | PIQNOTE_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID - Unique Note Identifier | ||
27 | .INCLUDE | 0 | 0 | Appraisal Additional Data | |||||
28 | CPATTEMP | PIQCPATTEMP | PIQCP | QUAN | 10 | 5 | Attempted Credits | ||
29 | CPEARNED | PIQCPEARNED | PIQCP | QUAN | 10 | 5 | Earned Credits | ||
30 | CPGRADED | PIQCPGRADED | PIQCP | QUAN | 10 | 5 | Graded Credits | ||
31 | CPUNIT | PIQCPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Credits | * | |
32 | .INCLUDE | 0 | 0 | ||||||
33 | .INCLU-506 | 0 | 0 | Additional Data for Relationship 506 | |||||
34 | SMSTATUS506 | PIQSMSTATUS | PIQSMSTATUS | NUMC | 2 | 0 | Module Booking Status | T7PIQSMSTAT | |
35 | STORREASON506 | PIQSTORREASON | PIQSTORREASON | CHAR | 4 | 0 | Cancellation Reason | T7PIQWITHDRAWN | |
36 | STORDATE506 | PIQSTORDATE | PIQSTORDATE | DATS | 8 | 0 | Cancellation Date | ||
37 | CPATTEMP506 | PIQCPATTEMP | PIQCP | QUAN | 10 | 5 | Attempted Credits | ||
38 | CPGAINED506 | PIQCPGAINED | PIQCP | QUAN | 10 | 5 | Earned Credits | ||
39 | CPUNIT506 | PIQCPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Credits | T006 | |
40 | NORM_VAL506 | PIQSCALE_NORM_VAL | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Std Value for Scale Value | ||
41 | BOOKDATE506 | PIQDATE | DATUM | DATS | 8 | 0 | Booking Date | ||
42 | BOOKTIME506 | PIQWAITL_TIME | TIME | TIMS | 6 | 0 | Booking Time | ||
43 | SMRATING506 | PIQSMRATING | PIQSMRATING | CHAR | 3 | 0 | Alternative Assessment Method for Module | T7PIQSMRATING | |
44 | CHARGEFREE506 | PIQCHARGE | PIQCHARGE | CHAR | 1 | 0 | Free of Charge | ||
45 | TRANSFERFLAG506 | PIQTRANSFER | PIQTRANSFER | CHAR | 1 | 0 | External Academic Work or Qualification Transferred | ||
46 | PACKNUMBER506 | PIQSLNUM | HROBJID | NUMC | 8 | 0 | Event Package | * | |
47 | VARID506 | PIQVARID | PIQVARID | CHAR | 2 | 0 | Session Variant | T7PIQVARY | |
48 | PERID506 | PIQPERID | PIQPERID | NUMC | 3 | 0 | Academic Session | T7PIQPERIOD | |
49 | PERYR506 | PIQPERYR | PIQPERYR | NUMC | 4 | 0 | Academic Year | T7PIQYEAR | |
50 | ALT_SCALEID506 | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
51 | ID506 | PIQMODREG_ID | SYSUUID_C | CHAR | 32 | 0 | Module Booking Identification | ||
52 | BOOKREASON506 | PIQBOOKREASON | PIQBOOKREASON | CHAR | 4 | 0 | Module Booking Reason | T7PIQBOOKREASON | |
53 | ANNULMENT506 | PIQMODREG_ANNULMENT | PIQMODREG_ANNULMENT | CHAR | 1 | 0 | Exclusion Indicator for Module Bookings | T7PIQ_MR_ANNUL | |
54 | LOCKFLAG506 | PIQAWLOCKFLAG | FLAG | CHAR | 1 | 0 | Change Lock | ||
55 | COBOK506 | PIQPEPE_COBOK | PIQPEPE_COBOK | CHAR | 1 | 0 | Conditional Booking | ||
56 | .INCLUDE | 0 | 0 | ||||||
57 | AGRTEXT | PIQAGRTEXT | TEXT50 | CHAR | 50 | 0 | Appraisal (Description) | ||
58 | SMSTATUST | PIQSMSTATUST | TEXT25 | CHAR | 25 | 0 | Module Booking Status (Description) | ||
59 | CANCELREASON_TXT | PIQSTORREASONT | PIQSTORREASONT | CHAR | 40 | 0 | Cancellation Reason (Description) | ||
60 | RATING_TXT | PIQSMRATINGT | PIQSMRATINGT | CHAR | 40 | 0 | Alternative Assessment Method for Module (Description) | ||
61 | EVENTPACKAGE_SHT | PIQSESHORT | TEXT12 | CHAR | 12 | 0 | Event Package (Abbreviation) | ||
62 | EVENTPACKAGE_TXT | PIQSESTEXT | TEXT40 | CHAR | 40 | 0 | Event Package (Description) | ||
63 | ACAD_SESSION_TXT | PIQPERIT | TEXT20 | CHAR | 20 | 0 | Academic Session (Description) | ||
64 | ACAD_YEAR_TXT | PIQPERYT | TEXT20 | CHAR | 20 | 0 | Academic Year (Description) | ||
65 | ACAD_PERID_TXT | PIQPERIT | TEXT20 | CHAR | 20 | 0 | Academic Session (Description) | ||
66 | BOOKREASON_TXT | PIQBOOKREASONT | TEXT40 | CHAR | 40 | 0 | Module Booking Reason (Description) | ||
67 | ANNULMENT_TXT | PIQMODREG_ANNULMENTT | TEXT40 | CHAR | 40 | 0 | Exclusion Indicator for Module Bookings (Description) | ||
68 | AGRTYPE_TXT | PIQAGRTYPET | TEXT25 | CHAR | 25 | 0 | Appraisal Type (Description) | ||
69 | AGRSTAT_TXT | PIQAGRSTATTEXT | TEXT30 | CHAR | 30 | 0 | Appraisal Status (Description) | ||
70 | GRADESYMBOL_TXT | PIQSCALE_GRADETEXT | PIQSCALE_GRADETEXT | CHAR | 20 | 0 | Scale Value (Description) | ||
71 | GRADESCALE_TXT | PIQSCALE_TEXT | PIQSCALE_TEXT | CHAR | 30 | 0 | Academic Scale (Description) | ||
72 | CPUNIT_TXT | PIQCPUNITT | TEXT25 | CHAR | 25 | 0 | Description of Credit Type Unit | ||
73 | AGRREMARK_TXT | PIQAGRREMARKT | TEXT30 | CHAR | 30 | 0 | Appraisal Remark (Description) | ||
74 | COBOK_TXT | PIQPEPE_COBOKT | TEXT40 | CHAR | 40 | 0 | Conditional Booking (Description) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PIQAGR_APPRDATA_DLG | ALT_SCALEID506 | T7PIQSCALE | SCALEID | |||
2 | PIQAGR_APPRDATA_DLG | ANNULMENT506 | T7PIQ_MR_ANNUL | ANNULMENT | |||
3 | PIQAGR_APPRDATA_DLG | APERIOD | T7PIQPERIOD | PERID | |||
4 | PIQAGR_APPRDATA_DLG | AYEAR | T7PIQYEAR | PERYR | |||
5 | PIQAGR_APPRDATA_DLG | BOOKREASON506 | T7PIQBOOKREASON | BOOKREASON | |||
6 | PIQAGR_APPRDATA_DLG | CPUNIT506 | T006 | MSEHI | |||
7 | PIQAGR_APPRDATA_DLG | PERID506 | T7PIQPERIOD | PERID | 1 | CN | |
8 | PIQAGR_APPRDATA_DLG | PERYR506 | T7PIQYEAR | PERYR | KEY | 1 | CN |
9 | PIQAGR_APPRDATA_DLG | SMRATING506 | T7PIQSMRATING | SMRATING | |||
10 | PIQAGR_APPRDATA_DLG | SMSTATUS506 | T7PIQSMSTAT | SMSTATUS | |||
11 | PIQAGR_APPRDATA_DLG | STORREASON506 | T7PIQWITHDRAWN | STORREASON | |||
12 | PIQAGR_APPRDATA_DLG | UPAGRID | PIQDBAGR_GEN | AGRID | |||
13 | PIQAGR_APPRDATA_DLG | VARID506 | T7PIQVARY | VARID | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 472 |