HRS_APP_DISFR_I

(SQL View)
 Index Back

Disability

French Specific Disability Information

SELECT HRS_PERSON_ID ,HRS_DISAB_TYPE_FRA ,DIS_BEGIN_DT_FRA ,DIS_END_DT_FRA ,DIS_COTOREP_RT_FRA ,DIS_IPP_RT_FRA ,DIS_PRIOR_PLC_FRA ,PLACEMENT_TYPE_FRA ,WRK_ACCDNT_DIS_FRA ,TITLE_NBR_FRA ,NOTIF_DT_FRA ,ACCDNT_ILLNESS_FRA ,OCC_ILLNESS_FRA ,%subrec(HRS_AUDIT_SBR,A) ,COMMENTS FROM PS_HRS_APP_DIS_FRA A

  • Parent record: HRS_APP_DIS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    2 HRS_DISAB_TYPE_FRA Character(3) VARCHAR2(3) NOT NULL Disability Type
    COT=Known as COTOREP
    FEM=Spouse of mentally disabled
    ORP=War Orphan
    PEN=Pensioned, Volunteer Fire Man
    TPI=Disability Pension Owner
    TPM=Disability Milit Pension Owner
    VAM=Work Accident or Disease
    VGN=Re-Married War Widow
    VGR=Not-Married War Widow
    3 DIS_BEGIN_DT_FRA Date(10) DATE Disability Begin Date
    4 DIS_END_DT_FRA Date(10) DATE Disability End Date
    5 DIS_COTOREP_RT_FRA Character(1) VARCHAR2(1) NOT NULL COTOREP Category
    A=COTOREP A - Category
    B=COTOREP B Category
    C=COTOREP C Category
    6 DIS_IPP_RT_FRA Number(6,2) DECIMAL(5,2) NOT NULL Disability Rate
    7 DIS_PRIOR_PLC_FRA Character(1) VARCHAR2(1) NOT NULL Previous Placement

    Y/N Table Edit

    Default Value: N

    8 PLACEMENT_TYPE_FRA Character(4) VARCHAR2(4) NOT NULL Previous Placement Type
    AP=Protected WorkShop
    CAT=Helped by a Work Center
    CDTD=Home Work Center
    CFP=Professional Training Center
    IMPR=Professional/Medical Center
    9 WRK_ACCDNT_DIS_FRA Character(1) VARCHAR2(1) NOT NULL Disability Due to WorkAccident

    Y/N Table Edit

    Default Value: N

    10 TITLE_NBR_FRA Character(12) VARCHAR2(12) NOT NULL Title Number
    11 NOTIF_DT_FRA Date(10) DATE Notification Date
    12 ACCDNT_ILLNESS_FRA Character(1) VARCHAR2(1) NOT NULL Accident Cause.
    A=Work Accident
    M=Disease
    13 OCC_ILLNESS_FRA Character(3) VARCHAR2(3) NOT NULL Professional Disease

    Prompt Table: OCC_ILLNESS_FRA

    14 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    15 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    16 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    17 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id
    18 COMMENTS Long Character CLOB Comment