PAY_TYPE |
Default Table Name | PAY_TYPE |
Definition |
PAY_TYPE Columns |
ColumnName | Domain | Datatype | NULL | Definition |
PAY_TYPE![]() |
VARCHAR2(3) | NO | ||
PAY_TYPE_DESC | VARCHAR2(30) | NO | ||
PAY_TYPE_FCTR_QTY | NUMBER(5, 4) | NO | ||
PAY_TYPE_AMT | NUMBER(10, 4) | NO | ||
S_PAY_TYPE_USE_CD | VARCHAR2(1) | NO | ||
APPLY_TO_EXMPT_FL | VARCHAR2(1) | NO | ||
CST_ONLY_FL | VARCHAR2(1) | NO | ||
S_INCL_WGT_AVG_CD | VARCHAR2(1) | NO | ||
ALLOW_RECAST_FL | VARCHAR2(1) | NO | ||
APPLY_SAL_EMPL_FL | VARCHAR2(1) | NO | ||
OT_PAY_TYPE_FL | VARCHAR2(1) | NO | ||
RECAST_PAY_TYPE | VARCHAR2(3) | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | NO | ||
APPLY_NON_EXMPT_FL | VARCHAR2(1) | NO | ||
BEN_REIMB_FL | VARCHAR2(1) | NO | ||
CALC_OT_PREM_FL | VARCHAR2(1) | NO | ||
ALLOC_OT_PREM_FL | VARCHAR2(1) | NO | ||
REIMB_FL | VARCHAR2(1) | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
LWOP_FL | VARCHAR2(1) | YES | ||
LWOP_NEG_FL | VARCHAR2(1) | YES | ||
SEVERANCE_FL | VARCHAR2(1) | YES | ||
FED_NONTAX_SICK_FL | VARCHAR2(1) | YES |
PAY_TYPE Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0149 | PrimaryKey | PAY_TYPE |
PAY_TYPE Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
EMPL_PAY_TYPE_DFLT | Identifying | One To Zero or More | F00790 | NO | NO | NO | |||
DFLT_REG_TS | Non-Identifying | One To Zero or More | F00880 | NO | NO | NO | |||
DFLT_OT_TS | Non-Identifying | One To Zero or More | F00881 | NO | NO | NO | |||
PAY_TYPE_RESTRICT | Non-Identifying | One To Zero or More | F02650 | NO | NO | NO | |||
TS_LN | Non-Identifying | One To Zero or More | F04880 | NO | NO | NO | |||
WD_FRNG_HANDLING | Non-Identifying | One To Zero or More | F05370 | NO | NO | NO | |||
OT_SETTINGS | Non-Identifying | One To Zero or More | F06441 | NO | NO | NO | |||
OT_SETTINGS | Non-Identifying | One To Zero or More | F06442 | NO | NO | NO | |||
DED_MOD_PAY_TYPE | Identifying | One To Zero or More | F08331 | NO | NO | NO | |||
DED_CD_CORP | Non-Identifying | One To Zero or More | F08344 | NO | NO | NO | |||
PAY_TYPE_TXBL | Identifying | One To Zero or More | F08590 | NO | NO | NO | |||
EMPL_TS_LN_TYPE_DF | Non-Identifying | One To Zero or More | F09830 | NO | NO | NO | |||
OT_PREM_RECAST | Non-Identifying | One To Zero or More | F09850 | NO | NO | NO | |||
NON_COMP_PAY_TYPE | Identifying | One To Zero or More | F09928 | NO | NO | NO | |||
HB_BEN_PLAN_HDR | Non-Identifying | One To Zero or More | F20909 | NO | NO | NO | |||
HB_SETTINGS | Non-Identifying | One To Zero or More | F20983 | NO | NO | NO | |||
HB_SETTINGS | Non-Identifying | One To Zero or More | F20985 | NO | NO | NO | |||
HB_SETTINGS | Non-Identifying | One To Zero or More | F20987 | NO | NO | NO | |||
WC_MOD_PAY_TYPE | Identifying | One To Zero or More | F21164 | NO | NO | NO | |||
ALLOWANCE_CD | Non-Identifying | One To Zero or More | F21264 | NO | NO | NO | |||
FRNG_MOD_PAY_TYPE | Identifying | One To Zero or More | F21310 | NO | NO | NO | |||
CREW_TS_LN | Non-Identifying | One To Zero or More | F21313 | NO | NO | NO | |||
UNION_PROFLE_FRNG | Non-Identifying | One To Zero or More | F21339 | NO | NO | NO | |||
DISP_INC_PAYTP | Identifying | One To Zero or More | F21718 | NO | NO | NO | |||
EMPL_GRN_DI_PT | Identifying | One To Zero or More | F21784 | NO | NO | NO | |||
H_POS_RQ_RQST | Non-Identifying | One To Zero or More | FK_H_POS_RQ_RQST_DFPA_IDX | NO | NO | NO | |||
PAY_TYPE_CUR_OVRD | Identifying | One To Zero or More | FK_PAY_TYPE_CUR_OVRD_PA_IDX | NO | NO | NO |