Z_PRREBOND_WRK1 |
Default Table Name | Z_PRREBOND_WRK1 |
Definition |
Z_PRREBOND_WRK1 Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID | VARCHAR2(12) | YES | ||
LAST_FIRST_NAME | VARCHAR2(25) | YES | ||
S_EMPL_STATUS_CD | VARCHAR2(3) | YES | ||
SSN_ID | VARCHAR2(11) | YES | ||
LN_1_ADR | VARCHAR2(30) | YES | ||
LN_2_ADR | VARCHAR2(30) | YES | ||
LN_3_ADR | VARCHAR2(30) | YES | ||
CITY_NAME | VARCHAR2(25) | YES | ||
STATE_CD | VARCHAR2(2) | YES | ||
POSTAL_CD | VARCHAR2(10) | YES | ||
SEQ_NO_01 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_01 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_01 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_01 | VARCHAR2(1) | YES | ||
SEQ_NO_02 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_02 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_02 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_02 | VARCHAR2(1) | YES | ||
SEQ_NO_03 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_03 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_03 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_03 | VARCHAR2(1) | YES | ||
SEQ_NO_04 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_04 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_04 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_04 | VARCHAR2(1) | YES | ||
SEQ_NO_05 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_05 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_05 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_05 | VARCHAR2(1) | YES | ||
SEQ_NO_06 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_06 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_06 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_06 | VARCHAR2(1) | YES | ||
SEQ_NO_07 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_07 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_07 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_07 | VARCHAR2(1) | YES | ||
SEQ_NO_08 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_08 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_08 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_08 | VARCHAR2(1) | YES | ||
SEQ_NO_09 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_09 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_09 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_09 | VARCHAR2(1) | YES | ||
SEQ_NO_10 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_10 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_10 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_10 | VARCHAR2(1) | YES | ||
SEQ_NO_11 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_11 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_11 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_11 | VARCHAR2(1) | YES | ||
SEQ_NO_12 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_12 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_12 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_12 | VARCHAR2(1) | YES | ||
SEQ_NO_13 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_13 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_13 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_13 | VARCHAR2(1) | YES | ||
SEQ_NO_14 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_14 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_14 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_14 | VARCHAR2(1) | YES | ||
SEQ_NO_15 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_15 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_15 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_15 | VARCHAR2(1) | YES | ||
SEQ_NO_16 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_16 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_16 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_16 | VARCHAR2(1) | YES | ||
SEQ_NO_17 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_17 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_17 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_17 | VARCHAR2(1) | YES | ||
SEQ_NO_18 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_18 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_18 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_18 | VARCHAR2(1) | YES | ||
SEQ_NO_19 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_19 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_19 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_19 | VARCHAR2(1) | YES | ||
SEQ_NO_20 | NUMBER(5, 0) | YES | ||
BOND_OCB_NAME_20 | VARCHAR2(33) | YES | ||
BOND_OCB_SSN_ID_20 | VARCHAR2(11) | YES | ||
BOND_OCB_TYPE_20 | VARCHAR2(1) | YES | ||
BOND_SERIES | VARCHAR2(2) | YES | ||
BOND_CD | VARCHAR2(1) | YES | ||
BOND_FACE_AMT | NUMBER(17, 2) | YES | ||
SPENT_AMT | NUMBER(17, 2) | YES | ||
UN_SPENT_AMT | NUMBER(17, 2) | YES | ||
BOND_CNT | NUMBER(10, 0) | YES | ||
BOND_DED_AMT | NUMBER(17, 2) | YES |
Z_PRREBOND_WRK1 Primary and Unique Keys |
Key Name | Key Type | Keys |
Z_PRREBOND_WRK1 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 |