SAP ABAP Table Q0743 (HR-SG-PS: 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
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | Q0743 |
|
| Short Description | HR-SG-PS: 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 | |
P25_OUTCD | P25_OUTCD | CHAR | 3 | 0 | Outcome code | T5RPBS10D | |
| 2 | |
P25_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
| 3 | |
P25_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
| 4 | |
P25_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
| 5 | |
P25_OUTMT | P25_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
| 6 | |
P25_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
| 7 | |
P25_OUTPR | DEC3_2 | DEC | 5 | 2 | Percentage of Penalty | ||
| 8 | |
P25_OUTIN | NUM02 | NUMC | 2 | 0 | No. of Increments reduced | ||
| 9 | |
P25_OUTND | DATS | DATS | 8 | 0 | NWC effective date | ||
| 10 | |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 11 | |
P25_INTYX | TEXT30 | CHAR | 30 | 0 | Description of interdiction type | ||
| 12 | |
P25_INTYX | TEXT30 | CHAR | 30 | 0 | Description of interdiction type | ||
| 13 | |
P25_INVNA | TEXT40 | CHAR | 40 | 0 | Name of the Investigating Officer | ||
| 14 | |
P25_REPNA | TEXT40 | CHAR | 40 | 0 | Name of the Officer's representative | ||
| 15 | |
P25_MINNA | TEXT40 | CHAR | 40 | 0 | Name of ministry's representative | ||
| 16 | |
P25_OUTTX | TEXT72 | CHAR | 72 | 0 | Description of outcome | ||
| 17 | |
P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
| 18 | |
P25_OFLTX | TEXT50 | CHAR | 50 | 0 | Long description of Offence | ||
| 19 | |
P25_OFFGX | TEXT50 | CHAR | 50 | 0 | Description of offence grouping | ||
| 20 | |
P25_OUTRE | TEXT72 | CHAR | 72 | 0 | Outcome Remarks | ||
| 21 | |
P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
| 22 | |
P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
| 23 | |
P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
| 24 | |
P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
| 25 | |
P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
| 26 | |
P25_INTTX | TEXT72 | CHAR | 72 | 0 | Description of Interdiction type | ||
| 27 | |
P25_OFFRE | TEXT72 | CHAR | 72 | 0 | Offence remarks | ||
| 28 | |
P25_OFFRE | TEXT72 | CHAR | 72 | 0 | Offence remarks | ||
| 29 | |
P25_OFFRE | TEXT72 | CHAR | 72 | 0 | Offence remarks | ||
| 30 | |
P25_COINE | TEXT40 | CHAR | 40 | 0 | Name of COI member | ||
| 31 | |
P25_COINE | TEXT40 | CHAR | 40 | 0 | Name of COI member |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | Q0743 | INTTY | |
|
KEY | 1 | CN |
| 2 | Q0743 | OFFCD | |
|
|||
| 3 | Q0743 | OUTCD | |
|
|||
| 4 | Q0743 | WAERS | |
|
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in | 46C |