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
⤷ PY-SG-PS (Application Component) Public Sector
⤷ P25P2 (Package) HR-Public Sector - Singapore - Add-on functionality
Basic Data
Table Category | INTTAB | Structure |
Structure | Q0743 | Table Relationship Diagram |
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 | OUTCD | P25_OUTCD | P25_OUTCD | CHAR | 3 | 0 | Outcome code | T5RPBS10D | |
2 | OUTDE | P25_OUTDE | DATS | DATS | 8 | 0 | Begin date of Outcome | ||
3 | OUTDF | P25_OUTDF | DATS | DATS | 8 | 0 | End date of Outcome | ||
4 | OUTDR | P25_OUTDR | NUM03 | NUMC | 3 | 0 | Duration of outcome | ||
5 | OUTMT | P25_OUTMT | P25_OUTMT | CHAR | 3 | 0 | Unit of Time/Measurement | ||
6 | OUTAT | P25_OUTAT | P_AMT07V | CURR | 13 | 2 | Amount of Penalty | ||
7 | OUTPR | P25_OUTPR | DEC3_2 | DEC | 5 | 2 | Percentage of Penalty | ||
8 | OUTIN | P25_OUTIN | NUM02 | NUMC | 2 | 0 | No. of Increments reduced | ||
9 | OUTND | P25_OUTND | DATS | DATS | 8 | 0 | NWC effective date | ||
10 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
11 | INTX1 | P25_INTYX | TEXT30 | CHAR | 30 | 0 | Description of interdiction type | ||
12 | INTX2 | P25_INTYX | TEXT30 | CHAR | 30 | 0 | Description of interdiction type | ||
13 | INVNA | P25_INVNA | TEXT40 | CHAR | 40 | 0 | Name of the Investigating Officer | ||
14 | REPNA | P25_REPNA | TEXT40 | CHAR | 40 | 0 | Name of the Officer's representative | ||
15 | MINNA | P25_MINNA | TEXT40 | CHAR | 40 | 0 | Name of ministry's representative | ||
16 | OUTTX | P25_OUTTX | TEXT72 | CHAR | 72 | 0 | Description of outcome | ||
17 | OFFCD | P25_OFFCD | P25_OFFCD | CHAR | 4 | 0 | Offence code | T5RPBS10B | |
18 | OFLTX | P25_OFLTX | TEXT50 | CHAR | 50 | 0 | Long description of Offence | ||
19 | OFFGX | P25_OFFGX | TEXT50 | CHAR | 50 | 0 | Description of offence grouping | ||
20 | OUTRE | P25_OUTRE | TEXT72 | CHAR | 72 | 0 | Outcome Remarks | ||
21 | INTTY | P25_INTTY | P25_INTTY | CHAR | 3 | 0 | Interdict/Stop pay type | T5RPBS10G | |
22 | INTBD | P25_INTBD | DATS | DATS | 8 | 0 | Begin date of Interdiction | ||
23 | INTED | P25_INTED | DATS | DATS | 8 | 0 | End date of Interdiction | ||
24 | INTRE | P25_INTRE | DATS | DATS | 8 | 0 | Effevtive date of restoration | ||
25 | INTAT | P25_INTAT | P_AMT07V | CURR | 13 | 2 | FP amount at interdiction | ||
26 | INTTX | P25_INTTX | TEXT72 | CHAR | 72 | 0 | Description of Interdiction type | ||
27 | OFFR1 | P25_OFFRE | TEXT72 | CHAR | 72 | 0 | Offence remarks | ||
28 | OFFR2 | P25_OFFRE | TEXT72 | CHAR | 72 | 0 | Offence remarks | ||
29 | OFFR3 | P25_OFFRE | TEXT72 | CHAR | 72 | 0 | Offence remarks | ||
30 | COIN1 | P25_COINE | TEXT40 | CHAR | 40 | 0 | Name of COI member | ||
31 | COIN2 | 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 | T5RPBS10G | INTYP | KEY | 1 | CN |
2 | Q0743 | OFFCD | T5RPBS10B | OFFCD | |||
3 | Q0743 | OUTCD | T5RPBS10D | OUTCD | |||
4 | Q0743 | WAERS | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |