RAT_PRO_LNG_BRA

(SQL View)
 Index Back

RAT Proceeding by Estab

RAT Proceeding by Estab Language

SELECT A.COMPANY , A.EFFDT , A.CREATED_FOR_BRA , CASE WHEN A.AUTH_BY_BRA <> '2' THEN '1' ELSE A.AUTH_BY_BRA END AS AUTH_BY_BRA , CASE WHEN A.PRC_TYPE_BRA = '1' THEN 'A' WHEN A.PRC_TYPE_BRA = '2' THEN 'J' WHEN A.PRC_TYPE_BRA = '4' THEN 'F' ELSE ' ' END AS PRC_TYPE_BRA , A.PROC_NBR_BRA , B.LANGUAGE_CD , B.DESCR100 FROM PS_LEG_PRO_TBL_BRA A , PS_LEG_PRO_LNG_BRA B WHERE A.COMPANY = B.COMPANY AND A.PRC_TYPE_BRA = B.PRC_TYPE_BRA AND A.PROC_NBR_BRA = B.PROC_NBR_BRA AND A.EFFDT = B.EFFDT

  • Related Language Record for RAT_PROC_VW_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 CREATED_FOR_BRA Character(2) VARCHAR2(2) NOT NULL Created For table 1070
    1=Tax only or Tax and FGTS
    2=Minor Work Permit
    2=Minor Work Permit
    3=Exemption to Contract PCD
    3=Exemption to Contract PCD
    4=Exemption for Hiring Aprentice
    4=Exemption for Hiring Aprentice
    5=Occupational Health and Safety
    5=Occupational Health and Safety
    6=Conv Health Leave to work Acc
    6=Conv Health Leave to work Acc
    7=FGTS only/Termination Soc Cont
    8=Union Contribution
    8=Union Contribution
    99=Other
    99=Other
    4 AUTH_BY_BRA Character(1) VARCHAR2(1) NOT NULL Authorized by BRA
    1=Taxpayer
    2=Other Entity,Company/Employee
    5 RAT_PROCEEDING_BRA Character(1) VARCHAR2(1) NOT NULL RAT Process Type Field
    A=Administrative
    J=Judicial
    N=None
    6 RAT_NBR_PROCED_BRA Character(30) VARCHAR2(30) NOT NULL RAT Process Number
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description