SAP ABAP Table PS0743 (HR Master Record Infotype 0743(Discipline))
Hierarchy
☛
SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
⤷ PY-SG-PS (Application Component) Public Sector
⤷ P25P2 (Package) HR-Public Sector - Singapore - Add-on functionality
⤷ PY-SG-PS (Application Component) Public Sector
⤷ P25P2 (Package) HR-Public Sector - Singapore - Add-on functionality
Basic Data
Table Category | INTTAB | Structure |
Structure | PS0743 | Table Relationship Diagram |
Short Description | HR Master Record Infotype 0743(Discipline) |
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 | INTY1 | P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
2 | INBD1 | P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
3 | INED1 | P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
4 | INRE1 | P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
5 | INAT1 | P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
6 | INTY2 | P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
7 | INBD2 | P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
8 | INED2 | P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
9 | INRE2 | P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
10 | INAT2 | P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
11 | INTY3 | P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
12 | INBD3 | P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
13 | INED3 | P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
14 | INRE3 | P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
15 | INAT3 | P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
16 | INTY4 | P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
17 | INBD4 | P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
18 | INED4 | P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
19 | INRE4 | P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
20 | INAT4 | P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
21 | INTY5 | P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
22 | INBD5 | P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
23 | INED5 | P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
24 | INRE5 | P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
25 | INAT5 | P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
26 | OFFDT | P25_OFFDT | DATS | DATS | 8 | 0 | Date of offence | ||
27 | DIACD | P25_DIACD | P25_DIACD | CHAR | 3 | 0 | Type of Disciplinary Action | T5RPBS10A | |
28 | INVDT | P25_INVDT | DATS | DATS | 8 | 0 | Begin date of investigation | ||
29 | DAKCR | P25_DAKCR | DATS | DATS | 8 | 0 | Date of acknowledgement of charge | ||
30 | OFFC1 | P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
31 | OFFC2 | P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
32 | OFFC3 | P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
33 | OFFC4 | P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
34 | OFFC5 | P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
35 | HEABD | P25_HEABD | DATS | DATS | 8 | 0 | Start date of Inquiry Period | ||
36 | HEAED | P25_HEAED | DATS | DATS | 8 | 0 | End date of Inquiry Period | ||
37 | INVPR | P25_INVPR | PERSNO | NUMC | 8 | 0 | Investigating officer's per no. | PA0003 | |
38 | COIP1 | P25_COIP1 | P25_COIP3 | CHAR | 20 | 0 | NOT Used. Reserved. | ||
39 | COIN1 | P25_DUMMY40 | TEXT40 | CHAR | 40 | 0 | Not Used. Reserved. | ||
40 | COIP2 | P25_COIP2 | P25_COIP3 | CHAR | 20 | 0 | NOT Used. Reserved. | ||
41 | COIN2 | P25_DUMMY40 | TEXT40 | CHAR | 40 | 0 | Not Used. Reserved. | ||
42 | COIP3 | P25_COIP3 | P25_COIP3 | CHAR | 20 | 0 | UIN/FIN of COI member 2 | ||
43 | COIN3 | P25_COINE | TEXT40 | CHAR | 40 | 0 | Name of COI member | ||
44 | TYPER | P25_TYPER | P25_TYPER | CHAR | 3 | 0 | Type of representation for officer | T5RPBS10E | |
45 | REPPR | P25_REPPR | P25_REPPR | CHAR | 20 | 0 | Officer's Representative's ID No. | ||
46 | REPNA | P25_REPNA | TEXT40 | CHAR | 40 | 0 | Name of the Officer's representative | ||
47 | MINPR | P25_MINPR | PERSNO | NUMC | 8 | 0 | Ministry's representative's per no. | PA0003 | |
48 | DACKP | P25_DACKP | DATS | DATS | 8 | 0 | Date of ack. of penalty | ||
49 | OUCD1 | P25_OUTCD | P25_OUTCD | CHAR | 3 | 0 | Outcome code | T5RPBS10D | |
50 | OUDE1 | P25_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
51 | OUDF1 | P25_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
52 | OUDR1 | P25_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
53 | OUMT1 | P25_OUTMT | P25_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
54 | OUAT1 | P25_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
55 | OUPR1 | P25_OUTPR | DEC3_2 | DEC | 5 | 2 | Percentage of Penalty | ||
56 | OUIN1 | P25_OUTIN | NUM02 | NUMC | 2 | 0 | No. of Increments reduced | ||
57 | OUND1 | P25_OUTND | DATS | DATS | 8 | 0 | NWC effective date | ||
58 | OUCD2 | P25_OUTCD | P25_OUTCD | CHAR | 3 | 0 | Outcome code | T5RPBS10D | |
59 | OUDE2 | P25_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
60 | OUDF2 | P25_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
61 | OUDR2 | P25_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
62 | OUMT2 | P25_OUTMT | P25_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
63 | OUAT2 | P25_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
64 | OUPR2 | P25_OUTPR | DEC3_2 | DEC | 5 | 2 | Percentage of Penalty | ||
65 | OUIN2 | P25_OUTIN | NUM02 | NUMC | 2 | 0 | No. of Increments reduced | ||
66 | OUND2 | P25_OUTND | DATS | DATS | 8 | 0 | NWC effective date | ||
67 | OUCD3 | P25_OUTCD | P25_OUTCD | CHAR | 3 | 0 | Outcome code | T5RPBS10D | |
68 | OUDE3 | P25_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
69 | OUDF3 | P25_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
70 | OUDR3 | P25_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
71 | OUMT3 | P25_OUTMT | P25_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
72 | OUAT3 | P25_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
73 | OUPR3 | P25_OUTPR | DEC3_2 | DEC | 5 | 2 | Percentage of Penalty | ||
74 | OUIN3 | P25_OUTIN | NUM02 | NUMC | 2 | 0 | No. of Increments reduced | ||
75 | OUND3 | P25_OUTND | DATS | DATS | 8 | 0 | NWC effective date | ||
76 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
77 | COIM1 | P25_COICH | PERSNO | NUMC | 8 | 0 | COI Chairman | PA0003 | |
78 | COIM2 | P25_COIMB | PERSNO | NUMC | 8 | 0 | COI Member's Id | PA0003 | |
79 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PS0743 | COIM1 | PA0003 | PERNR | |||
2 | PS0743 | COIM2 | PA0003 | PERNR | |||
3 | PS0743 | DIACD | T5RPBS10A | DIACD | KEY | 1 | CN |
4 | PS0743 | INTY1 | T5RPBS10G | INTYP | KEY | 1 | CN |
5 | PS0743 | INTY2 | T5RPBS10G | INTYP | KEY | 1 | CN |
6 | PS0743 | INTY3 | T5RPBS10G | INTYP | KEY | 1 | CN |
7 | PS0743 | INTY4 | T5RPBS10G | INTYP | KEY | 1 | CN |
8 | PS0743 | INTY5 | T5RPBS10G | INTYP | KEY | 1 | CN |
9 | PS0743 | INVPR | PA0003 | PERNR | |||
10 | PS0743 | MINPR | PA0003 | PERNR | KEY | 1 | CN |
11 | PS0743 | OFFC1 | T5RPBS10B | OFFCD | KEY | 1 | CN |
12 | PS0743 | OFFC2 | T5RPBS10B | OFFCD | KEY | 1 | CN |
13 | PS0743 | OFFC3 | T5RPBS10B | OFFCD | KEY | 1 | CN |
14 | PS0743 | OFFC4 | T5RPBS10B | OFFCD | KEY | 1 | CN |
15 | PS0743 | OFFC5 | T5RPBS10B | OFFCD | KEY | 1 | CN |
16 | PS0743 | OUCD1 | T5RPBS10D | OUTCD | KEY | 1 | CN |
17 | PS0743 | OUCD2 | T5RPBS10D | OUTCD | KEY | 1 | CN |
18 | PS0743 | OUCD3 | T5RPBS10D | OUTCD | KEY | 1 | CN |
19 | PS0743 | TYPER | T5RPBS10E | TYPER | KEY | 1 | CN |
20 | PS0743 | WAERS | TCURC | WAERS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 470 |