| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/C_RM_NNRES | Assignment for MRS Resource | 4 | GRADE | Grade | nvarchar | 8 | 0 | | |
2 | /ORS/APPRLIMIT | Approval Limit based on Grade Range, Expense Type and CC | 3 | GRADE | Authorization Grade Level or Range | nvarchar | 8 | 0 | | |
3 | /SLOAP/PRICING_1 | Conditions (1-Dimensional Quantity Scale) | 10 | GRADE | Scales are maintained | nvarchar | 1 | 0 | | |
4 | HRP1643 | DB Table for Infotype 1643 | 27 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
5 | HRP1650 | DB-Tabelle zum Infotyp 1650 | 19 | GRADE | Grade | nvarchar | 4 | 0 | | |
6 | HRP5221 | DB Table for Infotype 5221 | 24 | GRADE | Grade | nvarchar | 8 | 0 | | |
7 | P2RF_FPWP | PC2LF | 9 | GRADE | | nvarchar | 4 | 0 | | |
8 | PA0431 | HR Master Record, Infotype 0431 / View 0008 PSF | 25 | GRADE | | nvarchar | 4 | 0 | | |
9 | PA0576 | HR Master Record Infotype 0576 | 26 | GRADE | | nvarchar | 4 | 0 | | |
10 | PA0616 | HR Master Record: Infotype 0616 | 48 | GRADE | HESA: Grade structure | nvarchar | 2 | 0 | | |
11 | PA0623 | HR Master Record: Infotype 0623 | 32 | GRADE | Grade ID | nvarchar | 8 | 0 | | |
12 | PAPBSGB_HESA_C | HESA Archive table for NISR Contract table | 18 | GRADE | HESA: Grade structure | nvarchar | 2 | 0 | | |
13 | PB0623 | HR Master Record: Infotype 0623 | 32 | GRADE | Grade ID | nvarchar | 8 | 0 | | |
14 | PIQDB_DE_OTHGRD | Graduation from other programs of study | 13 | GRADE | Total Grade | nvarchar | 3 | 0 | | |
15 | PIQDB_DE_REPGRD | Graduation in the reporting semester | 20 | GRADE | Total Grade | nvarchar | 3 | 0 | | |
16 | T5FPBS4E | Affectation échelle, grade | 6 | GRADE | Grade | nvarchar | 4 | 0 | | |
17 | T5FPBS4G | Grade | 3 | GRADE | Grade | nvarchar | 4 | 0 | | |
18 | T5FPBS4GT | Libellé des grades | 4 | GRADE | Grade | nvarchar | 4 | 0 | | |
19 | T5FPBS5Q | Assignation d'une étape à un processus de promotion | 3 | GRADE | Grade cible | nvarchar | 4 | 0 | | |
20 | T5FPBSA2 | Grades | 3 | GRADE | Code grade dans l'ordre | nvarchar | 4 | 0 | | |
21 | T5FPBSA2T | Grade texts | 4 | GRADE | Code grade dans l'ordre | nvarchar | 4 | 0 | | |
22 | T5GPBSH_GRA | HESA: Grade structure | 2 | GRADE | HESA: Grade structure | nvarchar | 2 | 0 | | |
23 | T5GPBSH_GRAT | HESA: Grade structure (text) | 3 | GRADE | HESA: Grade structure | nvarchar | 2 | 0 | | |
24 | T5K13 | Jobs | 6 | GRADE | Wage group (Job Classification) | nvarchar | 8 | 0 | | |
25 | T7AEPBS02 | Rank/Grade | 3 | GRADE | Grade | nvarchar | 8 | 0 | | |
26 | T7AEPBS02T | Rank/Grade Text | 4 | GRADE | Grade | nvarchar | 8 | 0 | | |
27 | T7AEPBS06 | Job Classification | 7 | GRADE | Grade | nvarchar | 8 | 0 | | |
28 | T7AEPBS20 | Job Speciality Rule | 8 | GRADE | Grade | nvarchar | 8 | 0 | | |
29 | T7AEPBS56 | Job classification based education details for UAE PBS | 10 | GRADE | Grade | nvarchar | 8 | 0 | | |
30 | T7SAPBS02 | Rank/Grade | 3 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
31 | T7SAPBS02T | Rank/Grade Text | 4 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
32 | T7SAPBS06 | Job Classification | 6 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
33 | T7SAPBS20 | Job Speciality Rule | 8 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
34 | T7SAPBS20R | Job Speciality Rule | 10 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
35 | T7SAPBS34 | Assign Pay Scale to Job Classification | 6 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
36 | T7SAPBS65 | Job Relational Education | 6 | GRADE | Job Rank/Grade | nvarchar | 2 | 0 | | |
37 | T7SAPBS71 | Job Classification (Customer) | 6 | GRADE | Job Rank/Grade (Customer) | nvarchar | 2 | 0 | | |
38 | T7SAPBS72 | Rank/Grade (Customer) | 3 | GRADE | Job Rank/Grade (Customer) | nvarchar | 2 | 0 | | |
39 | T7SAPBS72T | Rank/Grade Text (Customer) | 4 | GRADE | Job Rank/Grade (Customer) | nvarchar | 2 | 0 | | |
40 | T7SAPBSM1 | Minimum Service Duration for KSA Military Sector | 10 | GRADE | Promotions: Education Grade | nvarchar | 2 | 0 | | |
41 | T7SAPBSM6 | Minimum Service Duration for KSA Military Sector | 8 | GRADE | Promotions: Education Grade | nvarchar | 2 | 0 | | |
42 | T7UNPF_FI_ADDET | Additional Details | 8 | GRADE | Salary Grade | tinyint | 3 | 0 | | |
43 | T7UNPF_FI_TRANS | Additional Details | 8 | GRADE | Salary Grade | tinyint | 3 | 0 | | |
44 | T7UNPF_HR_CATM | Mapping table for Pay scale type to Salary Category | 9 | GRADE | Salary Grade | tinyint | 3 | 0 | | |
45 | T7UNPF_HR_SAL | Salary details | 8 | GRADE | Salary Grade | tinyint | 3 | 0 | | |
46 | HRP1776 | DB Table for Infotype 1776 | 22 | GRADE | Obsolete | decimal | 8 | 2 | | |
47 | HRT1776 | Table Section for IT 1776 | 7 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
48 | PIQDBAGR_GEN | DB Table for Appraisals | 4 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
49 | PIQDBAPPR_AUD1 | Audit: Result Folder for Sub(Requirement) | 5 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
50 | PIQDBAPPR_AUD3 | (Sub)Requirement: Applicable Academic Work | 11 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
51 | PIQDBAPPR_AUD5 | Audit: Result Folder for Calculation | 5 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
52 | PIQDBPI_PINDEX | Performance Indexes | 21 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
53 | PIQPROC_ED_INT_W | ED Activity Document: Transferred Internal Academic Work | 8 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
54 | PIQPROC_PG_LI | Activity Document: Academic Performance Index | 6 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
55 | PIQPROC_PG_MB | Activity Document: Module Booking | 43 | GRADE | Std Value for Scale Value | decimal | 8 | 2 | | |
56 | T7PIQ_GB_POINTS | UCAS: Points Score for Entry to Higher Education | 3 | GRADE | Original Grade | nvarchar | 10 | 0 | | |
TOPBusiness Partner |
57 | BP1012 | Ratings | 9 | GRADE | Rating | nvarchar | 10 | 0 | | |
58 | BPCC_MIGCS_MAP | Assignment of Rating Procedure/Rating to Institution/Rating | 5 | GRADE | Rating | nvarchar | 10 | 0 | | |
59 | TPZ22 | Business Partner: Ratings | 3 | GRADE | Rating | nvarchar | 10 | 0 | | |
60 | TPZ22T | Business Partner: Description of Ratings | 3 | GRADE | Rating | nvarchar | 10 | 0 | | |
TOPBusiness Planning and Simulation |
61 | UPX_KPI_EVALBUF | KPI Valuation for Alert: Result Buffer | 5 | GRADE | Result of KPI Valuation: Rating | nvarchar | 1 | 0 | | |
TOPCollections Management |
62 | UDM_WL_ITEM | Worklist Item | 59 | GRADE | External Valuation | nvarchar | 10 | 0 | | |
TOPE-Recruiting |
63 | HRP5104 | DB Table for Infotype 5104 | 28 | GRADE | Final Grade | nvarchar | 4 | 0 | | |
TOPJapan |
64 | T5JLG | Premium amount for employment insurance | 1 | GRADE | Grade for employment insurance | nvarchar | 2 | 0 | | |
TOPKorea |
65 | PA0544 | HR Master Record: Infotype 0544 | 26 | GRADE | Grade | nvarchar | 4 | 0 | | |
66 | T7KR29 | SI grade table | 3 | GRADE | Grade | nvarchar | 4 | 0 | | |
TOPNon Profit Organizations |
67 | T7UNPAD_CEBGRD | EG CCAQ Staff Grade Mapping table | 6 | GRADE | CCAQ Staff Grade | nvarchar | 4 | 0 | | |
TOPReuse Services for Country Development |
68 | PA0861 | HR Master Record: Infotype 0861 | 34 | GRADE | | nvarchar | 4 | 0 | | |
TOPTalent Management |
69 | HRP7404 | Education | 28 | GRADE | Grade | nvarchar | 4 | 0 | | |
TOPUSA |
70 | T5U13 | Jobs | 6 | GRADE | Wage group (Job Classification) | nvarchar | 8 | 0 | | |