- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
T7PIQ_GB_SCHOOL
UCAS: Schools
|
#other
|
Component: United Kingdom
- 🔑 Keys (2)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (2)
- ☰ Categorical
- Other (36)
- 🔗 Relations (2)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| SCHOOL_ID | UCAS: School Number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| DTM_COLL | UCAS: Date annual data collected | |
| AEDTM | UCAS: Date of the last change made by UCAS |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| NAME | -Cm UCAS: Field description | TEXT50 | |
| COUNTRY_CODE | UCAS: School country/region code | PIQ_GB_UCAS_COUNTRY | |
| EST_GRP | UCAS: Establishment group | CHAR1 | |
| STATUS | UCAS: School status | CHAR1 | |
| DFE_ID | UCAS: DFE number | CHAR7 | |
| NC_ID | UCAS: National Centre Number (NCN) | CHAR5 | |
| BTEC_ID | UCAS: BTEC National Centre Number | CHAR6 | |
| HEAD_NAME | UCAS: Headmaster/Principal Name | PIQ_GB_UCAS_NAME | |
| HEAD_TITLE | UCAS: Headmaster/Principal Title | PIQ_GB_UCAS_NAME | |
| CONT_TITLE | UCAS: Usual Contact Title | PIQ_GB_UCAS_NAME | |
| CONT_NAME | UCAS: Usual Contact Name | PIQ_GB_UCAS_NAME | |
| ADDRESS_1 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS_LINE | |
| ADDRESS_2 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS_LINE | |
| ADDRESS_3 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS_LINE | |
| ADDRESS_4 | UCAS: Address line | PIQ_GB_UCAS_ADDRESS_LINE | |
| POSTCODE | Postal Code | PSTLZ | |
| TELNR | Telephone Number | CHAR25 | |
| DAY_BOARD | UCAS: School Day Board | CHAR1 | |
| SEX | UCAS: School Sexes | CHAR1 | |
| ROLL_NR | UCAS: Number on Roll | CHAR1 | |
| FULL_TIME | UCAS: Full Time | CHAR1 | |
| FIFTH_FORM | UCAS: Fifth Form | CHAR1 | |
| SIXTH_FORM | UCAS: Sixth Form | CHAR1 | |
| HI_EDUCAT | UCAS: Higher Education | CHAR1 | |
| WELSH | UCAS: Welshs Schools Main Language | CHAR1 | |
| TOWN | City | TEXT40 | |
| COUNTY | Description | TEXT20 | |
| LEA_CODE | UCAS: LEA code | PIQ_GB_UCAS_LEA | |
| PREV_SCHOOL_ID | UCAS: Previous School ID | PIQ_GB_UCAS_SCHOOL | |
| BASE_YEAR | UCAS: Base Year | PIQ_GB_UCAS_YEAR | |
| NO_APPLIC | UCAS: Number of UCAS Applicants | NUM4 | |
| NO_ACCEPT | UCAS: Number of UCAS Acceptances | NUM4 | |
| FORMS | UCAS: Forms processed | CHAR1 | |
| FAX | Fax Number | CHAR25 | |
| UCAS: Email address | |||
| UKPRN_NUM | CM UCAS : External Reference Number Assigned by UKRLP | PIQ_GB_UCAS_UKPRN |
| Master Data Relations | Join Conditions |
|---|---|
| Client | T7PIQ_GB_SCHOOL.MANDT == T000.MANDT |
UCAS: School type
|
|