HS_INJURY_TYPE_IND1=Partial
2=Total
HS_DISABL_CD_INDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
HS_DISABL_IND(SQL Table) |
Index Back |
|---|---|
Disablement Table for IndiaThis Record is for India Disablement,which captures the Injury type,Disablement code,Percentage loss of Earnings and the Descriptions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HS_INJURY_TYPE_IND |
Character(1) | VARCHAR2(1) NOT NULL |
This field defines the Injury type for India
1=Partial 2=Total |
| 2 | HS_DISABL_CD_IND |
Character(3) | VARCHAR2(3) NOT NULL | This field defines the Disablement Code for India |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | HS_PCT_LOSS_IND | Number(3,0) | SMALLINT NOT NULL | This field defines the percentage loss of earnings for specific Disablement Type for India. |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |