SAP ABAP Table PS0617 (HR Master data: Clinical Details (GB))

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB-PS (Application Component) Öffentlicher Dienst
     ⤷ P08P_HER (Package) HR Public Sector Great Britain (Higher Education)

Basic Data

Table Category	INTTAB	Structure
Structure	PS0617	Table Relationship Diagram
Short Description	HR Master data: Clinical Details (GB)

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	NTNUM	☐	P08_CLIN_NTNUM	CHAR13	CHAR	13	0	National training number
2	REGTY	☐	P08_CLIN_REGTY	P08_CLIN_REGTY	CHAR	3	0	Registration type	T5GPBSC_REG
3	REGNO	☐	P08_CLIN_REGNO	CHAR16	CHAR	16	0	Registration number
4	REGDT	☐	P08_CLIN_REGDT	DATUM	DATS	8	0	Expiry date of professional registration
5	SPECL	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
6	BASED	☐	P08_CLIN_BASED	P08_CLIN_BASED	CHAR	3	0	Hospital	T5GPBSC_BAS
7	CLACC	☐	P08_CLIN_CLACC	XFELD	CHAR	1	0	Clinical access confirmed
8	TRUST	☐	P08_CLIN_TRUST	P08_CLIN_TRUST	CHAR	3	0	Health Trust	T5GPBSC_TRU
9	NHSPC	☐	P08_CLIN_NHSPC	DEC3_2	DEC	5	2	% time worked for NHS
10	NHSSL	☐	P08_CLIN_NHSSL	DEC3_2	DEC	5	2	% salary from NHS
11	UNISW	☐	P08_CLIN_UNISW	P08_SESSIONS	DEC	3	1	University sessions worked
12	NHSSW	☐	P08_CLIN_NHSSW	P08_SESSIONS	DEC	3	1	NHS sessions worked
13	UNISC	☐	P08_CLIN_UNISC	P08_SESSIONS	DEC	3	1	University sessions charged
14	NHSSC	☐	P08_CLIN_NHSSC	P08_SESSIONS	DEC	3	1	NHS sessions charged
15	APLSB	☐	P08_CLIN_APLSB	XFELD	CHAR	1	0	A+B appointment
16	HONHS	☐	P08_CLIN_HONHS	P08_CLIN_HONHS	CHAR	3	0	Honorary NHS type	T5GPBSC_HON
17	HEINHS	☐	P08P_CLIN_HEINHS	XFELD	CHAR	1	0	HESA: Joint HEI/NHS contract (clinical)
18	CLINICAL	☐	P08P_CLIN_CLINICAL	P08P_HESA_CLINICAL	CHAR	1	0	HESA: Clinical Status
19	CLINARD	☐	P08P_HESA_CLINARD	P08P_HESA_CLINARD	CHAR	2	0	HESA: Clinical excellence award
20	SUBCL1	☐	P08P_HESA_SUBCLIN	P08P_HESA_SUBCLIN	CHAR	4	0	HESA: Clinical sub-specialty
21	SUBCL2	☐	P08P_HESA_SUBCLIN	P08P_HESA_SUBCLIN	CHAR	4	0	HESA: Clinical sub-specialty
22	SUBCL3	☐	P08P_HESA_SUBCLIN	P08P_HESA_SUBCLIN	CHAR	4	0	HESA: Clinical sub-specialty
23	SPECL2	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
24	SPECL3	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
25	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0617	BASED	T5GPBSC_BAS	BASED	KEY
2	PS0617	HONHS	T5GPBSC_HON	HONHS	KEY	1	CN
3	PS0617	REGTY	T5GPBSC_REG	REGTY	KEY	1	CN
4	PS0617	SPECL	T5GPBSC_SPE	SPECL	KEY
5	PS0617	SPECL2	T5GPBSC_SPE	SPECL
6	PS0617	SPECL3	T5GPBSC_SPE	SPECL
7	PS0617	TRUST	T5GPBSC_TRU	TRUST	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in