SAP ABAP Table PIQAGRSS_APPRAISAL (Appraisal Self-Service Web Dynpro: Appraisal)
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 | PIQAGRSS_APPRAISAL | Table Relationship Diagram |
Short Description | Appraisal Self-Service Web Dynpro: Appraisal |
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 Buffer Table | |||||
2 | INDX | PIQAGRLFNR | INT4 | INT4 | 10 | 0 | Sequence Number | ||
3 | .INCLUDE | 0 | 0 | Structure for Calculation Status Display (Appraisal) | |||||
4 | ICON_RESULT | PIQAGR_ICONRESULT | CHAR35 | CHAR | 35 | 0 | Result Origin (Icon) | ||
5 | VALUE_RESULT | PIQAGR_VALUERESULT | NUMC1 | NUMC | 1 | 0 | Result Value | ||
6 | ICON_CALCULATION | PIQAGR_ICON_CALCULATION | CHAR35 | CHAR | 35 | 0 | Degree of Reliability (Icon) | ||
7 | VALUE_CALCULATION | PIQAGR_VALUECALCULATION | NUMC1 | NUMC | 1 | 0 | Calculation Status | ||
8 | ICON_LOCK | PIQAGR_ICONLOCK | CHAR35 | CHAR | 35 | 0 | Calculation Lock (Icon) | ||
9 | VALUE_LOCK | PIQAGR_LOCK | NUMC1 | NUMC | 1 | 0 | Calculation Lock | ||
10 | .INCLUDE | 0 | 0 | Student Information for Appraisal | |||||
11 | STUDENTNUMBER | PIQSTUDENT12 | PIQSTUDENT12 | CHAR | 12 | 0 | Student Number | ||
12 | STUDENTNAME | STEXT | TEXT40 | CHAR | 40 | 0 | Object Name | ||
13 | FIRST_NAME | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
14 | LAST_NAME | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
15 | PERSIDNO | PIQ_PRDNI | CHAR20 | CHAR | 20 | 0 | Identification Number | ||
16 | NAME_AT_BIRTH | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
17 | .INCLUDE | 0 | 0 | BAPI Structure for Student: Org. Unit (Text Fields) | |||||
18 | ASSIGNED_ORGUNIT | PIQSTORGUNIT_ASSIGNED | HROBJID | NUMC | 8 | 0 | Assigned Organizational Unit of Student | * | |
19 | ASSIGNED_ORGUNIT_TXT | PIQSTORGTX | TEXT40 | CHAR | 40 | 0 | Name of the Student's Organizational Unit | ||
20 | ASSIGNED_ORGUNIT_SHT | PIQSTORGSHT | TEXT12 | CHAR | 12 | 0 | Organizational Unit of Student (Abbreviation) | ||
21 | .INCLUDE | 0 | 0 | Program/Study (Short and Long Texts) | |||||
22 | .INCLUDE | 0 | 0 | Program/Study/Student | |||||
23 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | * | |
24 | ST_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
25 | ST_OBJID | PIQST_OBJID | HROBJID | NUMC | 8 | 0 | Object ID of Student | * | |
26 | CS_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
27 | CS_OBJID | PIQCSOBJID | HROBJID | NUMC | 8 | 0 | Object ID of Study Object (CS) | * | |
28 | SC_OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | * | |
29 | SC_OBJID | PIQSCOBJID | HROBJID | NUMC | 8 | 0 | Program ID | * | |
30 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
31 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
32 | PRIOX | PIQCSPRIOX | CHAR2 | CHAR | 2 | 0 | Program Priority (In Period) | ||
33 | SC_SHORT | PIQSCSRK | CHAR12 | CHAR | 12 | 0 | Program of Study | ||
34 | SC_STEXT | PIQSCTXT | TEXT40 | CHAR | 40 | 0 | Program Description | ||
35 | .INCLUDE | 0 | 0 | Appraisal Buffer Structure | |||||
36 | .INCLUDE | 0 | 0 | Program Description | |||||
37 | STUDY | PIQAGRSTUDEY | CHAR40 | CHAR | 40 | 0 | Program | ||
38 | .INCLUDE | 0 | 0 | Grading Scale Description | |||||
39 | GRADESCALET | PIQSCALE_TEXT | PIQSCALE_TEXT | CHAR | 30 | 0 | Academic Scale (Description) | ||
40 | .INCLUDE | 0 | 0 | Appraisal | |||||
41 | AGRID | PIQAGRID | SYSUUID_C | CHAR | 32 | 0 | Appraisal ID | ||
42 | .INCLUDE | 0 | 0 | Appraisal: Administration Data | |||||
43 | ATTNO | PIQAGR_ATTNO | NUM03 | NUMC | 3 | 0 | Repetition Attempt Number | ||
44 | AGRTYPE | PIQAGRTYPE | PIQAGRTYPE | NUMC | 4 | 0 | Appraisal Type | T7PIQAGR_TYPE | |
45 | AGRSTAT | PIQAGRSTAT | PIQAGRSTAT | CHAR | 5 | 0 | Appraisal Status | T7PIQAGRC_STAT | |
46 | ARCH_STATUS | PIQAGR_ARCH_STATUS | PIQAGR_ARCH_STATUS | CHAR | 1 | 0 | Appraisal Archiving Status | ||
47 | AGRREMARK | PIQAGRREMARK | PIQAGRREMARK | CHAR | 2 | 0 | Appraisal Remark | * | |
48 | AYEAR | PIQPERYR | PIQPERYR | NUMC | 4 | 0 | Academic Year | T7PIQYEAR | |
49 | APERIOD | PIQPERID | PIQPERID | NUMC | 3 | 0 | Academic Session | T7PIQPERIOD | |
50 | .INCLUDE | 0 | 0 | Appraisal Validity | |||||
51 | AGRBEGDA | PIQAGRBEGDA | PIQDATE | DATS | 8 | 0 | Start of Appraisal Validity | ||
52 | AGRENDDA | PIQAGRENDDA | PIQDATE | DATS | 8 | 0 | End of Appraisal Validity | ||
53 | AGRDATEE | PIQAGRDATEE | PIQDATE | DATS | 8 | 0 | Earliest Appraisal Date | ||
54 | AGRDATEL | PIQAGRDATEL | PIQDATE | DATS | 8 | 0 | Latest Appraisal Date | ||
55 | .INCLUDE | 0 | 0 | Appraisal Relationship Information | |||||
56 | AGRWEIGHT | PIQAGRWEIGHT | PIQAGRWEIGHT | DEC | 5 | 2 | Appraisal Weighting | ||
57 | UPAGRID | PIQAGRID | SYSUUID_C | CHAR | 32 | 0 | Appraisal ID | PIQDBAGR_GEN | |
58 | .INCLUDE | 0 | 0 | Grading Information | |||||
59 | GRADESYM | PIQGRADESYM | PIQGRADESYM | CHAR | 10 | 0 | Grade Symbol | ||
60 | GRADE | PIQSCALE_NORM_VAL | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Std Value for Scale Value | ||
61 | GRADESCALE | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
62 | AGRNOTRATED | PIQAGRNOTRATED | PIQAGRNOTRATED | CHAR | 1 | 0 | Appraisal Grade Not Relevant | ||
63 | AGRDATE | PIQAGRDATE | PIQDATE | DATS | 8 | 0 | Appraisal Date | ||
64 | AGRCOMPLETED | PIQAGRCOMPLETED | PIQAGRCOMPLETED | CHAR | 1 | 0 | Appraisal Completed | ||
65 | NOTEID | PIQNOTE_GUID | SYSUUID_C | CHAR | 32 | 0 | GUID - Unique Note Identifier | ||
66 | .INCLU-TXT | 0 | 0 | Appraisal (Description) | |||||
67 | AGRIDTXT | PIQAGRID | SYSUUID_C | CHAR | 32 | 0 | Appraisal ID | ||
68 | .INCLUDE | 0 | 0 | Appraisal (Description) | |||||
69 | LANGUTXT | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
70 | AGRTEXTTXT | PIQAGRTEXT | TEXT50 | CHAR | 50 | 0 | Appraisal (Description) | ||
71 | .INCLU-APE | 0 | 0 | Appraisee | |||||
72 | OTYPEAPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
73 | REALOAPE | REALO | CHAR45 | CHAR | 45 | 0 | Extended Object ID | ||
74 | PLVARAPE | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
75 | .INCLU-ASG | 0 | 0 | Appraised Object | |||||
76 | AGRPLVARASG | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
77 | AGROTYPEASG | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
78 | AGRREALOASG | REALO | CHAR45 | CHAR | 45 | 0 | Extended Object ID | ||
79 | INFTYASG | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T777D | |
80 | RSIGNASG | RSIGN | RSIGN | CHAR | 1 | 0 | Relationship Specification | ||
81 | RELATASG | RELAT | RELAT | CHAR | 3 | 0 | Relationship Between Objects | T778V | |
82 | ISTATASG | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
83 | PRIOXASG | PRIOX | CHAR2 | CHAR | 2 | 0 | Priority | ||
84 | BEGDAASG | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
85 | ENDDAASG | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
86 | VARYFASG | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
87 | SEQNRASG | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
88 | SCLASASG | SCLAS | OTYPE | CHAR | 2 | 0 | Type of Related Object | T778O | |
89 | SOBIDASG | SOBID | CHAR45 | CHAR | 45 | 0 | ID of Related Object | ||
90 | MODREG_IDASG | PIQMODREG_ID | SYSUUID_C | CHAR | 32 | 0 | Module Booking Identification | ||
91 | .INCLU-APR | 0 | 0 | Appraiser (Functions) | |||||
92 | SEQNRAPR | PIQAGR_FUNC_SEQNR | PIQSEQNR | NUMC | 3 | 0 | Sequence Number of Function | ||
93 | .INCLUDE | 0 | 0 | Appraiser | |||||
94 | OTYPEAPR | PIQAGR_APPSER_TYPE | OTYPE | CHAR | 2 | 0 | Object Type of the Appraiser | T778O | |
95 | REALOAPR | PIQAGR_APPSER_ID | CHAR45 | CHAR | 45 | 0 | Identification (ID) of the Appraiser | ||
96 | PLVARAPR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
97 | FUNCTIONAPR | PIQAGR_APPFUNCTION | PIQAGR_APPFUNCTION | CHAR | 4 | 0 | Function Exercised (Abbreviation | * | |
98 | .INCLU-FOL | 0 | 0 | Appraisal Additional Data | |||||
99 | CPATTEMPFOL | PIQCPATTEMP | PIQCP | QUAN | 10 | 5 | Attempted Credits | ||
100 | CPEARNEDFOL | PIQCPEARNED | PIQCP | QUAN | 10 | 5 | Earned Credits | ||
101 | CPGRADEDFOL | PIQCPGRADED | PIQCP | QUAN | 10 | 5 | Graded Credits | ||
102 | CPUNITFOL | PIQCPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Credits | * | |
103 | .INCLUDE | 0 | 0 | ||||||
104 | AGRSTATTEXT | PIQAGRSTATTEXT | TEXT30 | CHAR | 30 | 0 | Appraisal Status (Description) | ||
105 | AGRREMARKTEXT | PIQAGRREMARKTEXT | TEXT35 | CHAR | 35 | 0 | Appraisal Remark (Description) | ||
106 | .INCLUDE | 0 | 0 | Additional Data for Relationship 506 | |||||
107 | SMSTATUS | PIQSMSTATUS | PIQSMSTATUS | NUMC | 2 | 0 | Module Booking Status | T7PIQSMSTAT | |
108 | STORREASON | PIQSTORREASON | PIQSTORREASON | CHAR | 4 | 0 | Cancellation Reason | T7PIQWITHDRAWN | |
109 | STORDATE | PIQSTORDATE | PIQSTORDATE | DATS | 8 | 0 | Cancellation Date | ||
110 | CPATTEMP | PIQCPATTEMP | PIQCP | QUAN | 10 | 5 | Attempted Credits | ||
111 | CPGAINED | PIQCPGAINED | PIQCP | QUAN | 10 | 5 | Earned Credits | ||
112 | CPUNIT | PIQCPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measurement for Credits | T006 | |
113 | NORM_VAL | PIQSCALE_NORM_VAL | PIQSCALE_NORM_VAL | DEC | 8 | 2 | Std Value for Scale Value | ||
114 | BOOKDATE | PIQDATE | DATUM | DATS | 8 | 0 | Booking Date | ||
115 | BOOKTIME | PIQWAITL_TIME | TIME | TIMS | 6 | 0 | Booking Time | ||
116 | SMRATING | PIQSMRATING | PIQSMRATING | CHAR | 3 | 0 | Alternative Assessment Method for Module | T7PIQSMRATING | |
117 | CHARGEFREE | PIQCHARGE | PIQCHARGE | CHAR | 1 | 0 | Free of Charge | ||
118 | TRANSFERFLAG | PIQTRANSFER | PIQTRANSFER | CHAR | 1 | 0 | External Academic Work or Qualification Transferred | ||
119 | PACKNUMBER | PIQSLNUM | HROBJID | NUMC | 8 | 0 | Event Package | * | |
120 | VARID | PIQVARID | PIQVARID | CHAR | 2 | 0 | Session Variant | T7PIQVARY | |
121 | PERID | PIQPERID | PIQPERID | NUMC | 3 | 0 | Academic Session | T7PIQPERIOD | |
122 | PERYR | PIQPERYR | PIQPERYR | NUMC | 4 | 0 | Academic Year | T7PIQYEAR | |
123 | ALT_SCALEID | PIQSCALE_ID | PIQSCALE_ID | CHAR | 4 | 0 | Academic Scale Identification (ID) | T7PIQSCALE | |
124 | ID | PIQMODREG_ID | SYSUUID_C | CHAR | 32 | 0 | Module Booking Identification | ||
125 | BOOKREASON | PIQBOOKREASON | PIQBOOKREASON | CHAR | 4 | 0 | Module Booking Reason | T7PIQBOOKREASON | |
126 | ANNULMENT | PIQMODREG_ANNULMENT | PIQMODREG_ANNULMENT | CHAR | 1 | 0 | Exclusion Indicator for Module Bookings | T7PIQ_MR_ANNUL | |
127 | LOCKFLAG | PIQAWLOCKFLAG | FLAG | CHAR | 1 | 0 | Change Lock | ||
128 | COBOK | PIQPEPE_COBOK | PIQPEPE_COBOK | CHAR | 1 | 0 | Conditional Booking | ||
129 | .INCLUDE | 0 | 0 | ||||||
130 | SMSTATUST | PIQSMSTATUST | TEXT25 | CHAR | 25 | 0 | Module Booking Status (Description) | ||
131 | SMRATINGT | PIQSMRATINGT | PIQSMRATINGT | CHAR | 40 | 0 | Alternative Assessment Method for Module (Description) | ||
132 | PUSHNOTES | PIQAGRPUSHNOTES | CHAR30 | CHAR | 30 | 0 | Notes | ||
133 | GRADESUM | QUAN1 | MENG8 | QUAN | 15 | 3 | Quantity | ||
134 | PIQFLAG | PIQAGRFLAG | CHAR01 | CHAR | 1 | 0 | Indicator | ||
135 | SUBTYPTERM | PIQAGRSUBTYP | PIQAGRSUBTYP | NUMC | 4 | 0 | Appraisal Type (Obsolete) | ||
136 | LFNR | PIQAGRLFNR | INT4 | INT4 | 10 | 0 | Sequence Number | ||
137 | REFINDX | PIQAGRLFNR | INT4 | INT4 | 10 | 0 | Sequence Number | ||
138 | ICONATTNO | PIQAGR_ICONATTNO | CHAR35 | CHAR | 35 | 0 | Repetition Attempt (Icon) | ||
139 | ICONCOBOK | PIQAGR_ICONCOBOK | TEXT35 | CHAR | 35 | 0 | Conditional Booking (Icon) | ||
140 | GRADETEXT | PIQSCALE_GRADETEXT | PIQSCALE_GRADETEXT | CHAR | 20 | 0 | Scale Value (Description) | ||
141 | APPSERTEXT | PIQAGR_APPSER_TXT | TEXT50 | CHAR | 50 | 0 | Name of Appraiser | ||
142 | .INCLUDE | 0 | 0 | Appraisal Self-Service Web Dynpro: Dialog Control Parameters | |||||
143 | ACT | PIQAGR_PROC | PIQAGR_PROC | CHAR | 4 | 0 | Processing Action for Appraisals | ||
144 | ELOCK | PIQAGRSS_EDIT_LOCKED | PIQAGRSS_EDIT_LOCKED | CHAR | 1 | 0 | Obsolete: Editing Is Locked | ||
145 | RESP | PIQAGR_RESPONSIBLE | PIQAGR_RESPONSIBLE | CHAR | 1 | 0 | Person Responsible | ||
146 | SAVE_OK | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
147 | VISIBLE | PIQFLAG | FLAG | CHAR | 1 | 0 | General Indicator | ||
148 | .INCLU-ROL | 0 | 0 | Editable Appraisal Data | |||||
149 | GRADESYMROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
150 | AGRDATEROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
151 | AGRBEGDAROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
152 | AGRENDDAROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
153 | AGRSTATUSROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
154 | AGRNOTEROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
155 | CPEARNEDROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
156 | CPGRADEDROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
157 | AGRCOMPLETEDROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
158 | AGRNOTRATEDROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected | ||
159 | AGRREMARKROL | PIQAGRSS_READ_ONLY | PIQAGRSS_READ_ONLY | CHAR | 1 | 0 | Field is Write Protected |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |