| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CRB | Alteracoes Contratuais Trabal. | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| CRB_FILIAL | C | 2 | 0 | Filial | R | S | |||||
| CRB_ID | C | 6 | 0 | Id. Trab. | @! | R | S | ||||
| CRB_VERSAO | C | 14 | 0 | Id. Ver. Reg | @! | R | S | ||||
| CRB_CODTRA | C | 6 | 0 | Id.Trabal. | @! | xFunVldCmp("C9V",,,,2,,,.T.) | C9V | R | S | ||
| CRB_DCODTR | C | 220 | 0 | Nome Trabal. | @! | V | S | ||||
| CRB_DTALTC | D | 8 | 0 | Dt Alter Con | R | S | |||||
| CRB_TPREGT | C | 1 | 0 | Tp Reg Trab | @! | Pertence(" 123") | R | 1=CLT - Consolidacao das Leis de Trabalho;2=RJU - Regime Juridico Unico;3=RJP - Regime Juridico Proprio | S | ||
| CRB_TPREGP | C | 1 | 0 | Tp Reg Prev | @! | Pertence(" 123") | R | 1=RGPS-Reg. Geral Previdencia Social;2=RPPS-Reg. Proprio Previdencia Social;3=RPPE-Reg. Proprio Previdencia Social no Exterior | S | ||
| CRB_NATATV | C | 1 | 0 | Nat. Ativid. | @! | Pertence(" 12") | R | 1=Trabalho Urbano;2=Trabalho Rural | S | ||
| CRB_CODCAT | C | 6 | 0 | Id. Cat. | @! | xFunVldCmp("C87",,,,2,.T.) | C87 | R | S | ||
| CRB_DCODCA | C | 220 | 0 | Descr. Cat. | @! | V | S | ||||
| CRB_CODCGO | C | 6 | 0 | Cod. Cargo | @! | xFunVldCmp("C8V",,,,2,,.T.) | C8V | R | S | ||
| CRB_DCODCG | C | 220 | 0 | Descr. Cargo | @! | V | S | ||||
| CRB_CODFUN | C | 6 | 0 | Cod. Funcao | @! | xFunVldCmp("C8X",,,,2,,.T.) | C8X | R | S | ||
| CRB_DCODFU | C | 220 | 0 | Descr Funcao | @! | V | S | ||||
| CRB_VLSLFX | N | 16 | 2 | Vlr Sal Fixo | @E 9,999,999,999,999.99 | R | S | ||||
| CRB_UNSLFX | C | 1 | 0 | Und Sal Fixo | @! | Pertence(" 12345") | R | 1=Por Hora;2=Por Dia;3=Por Semana;4=Por Mes;5=Por Tarefa | S | ||
| CRB_VLSLVR | N | 16 | 2 | Vlr Sal Var | @E 9,999,999,999,999.99 | R | S | ||||
| CRB_UNSLVR | C | 1 | 0 | Und Sal Var | @! | Pertence(" 12345") | R | 1=Por Hora;2=Por Dia;3=Por Semana;4=Por Mes;5=Por Tarefa | S | ||
| CRB_TPCONT | C | 1 | 0 | Tp. Contrato | @! | Pertence(" 12") | R | 1=Prazo indeterminado;2=Prazo determinado | S | ||
| CRB_DTTERM | D | 8 | 0 | Dt Term Con | R | S | |||||
| CRB_TPINSC | C | 1 | 0 | Tp Inscricao | @! | Pertence(" 1234") | R | 1=CNPJ;2=CPF;3=CAEPF;4=CNO | S | ||
| CRB_NRINSC | C | 14 | 0 | Nr Inscricao | @! | R | S | ||||
| CRB_CODLOT | C | 6 | 0 | Id. Lotacao | @! | xFunVldCmp("C99",,,,2,,.T.) | C99 | R | S | ||
| CRB_DCODLO | C | 220 | 0 | Des Lotacao | @! | V | S | ||||
| CRB_COMLOT | C | 80 | 0 | Comp Lotacao | @! | R | S | ||||
| CRB_QTDHJP | N | 2 | 0 | Qtd. Horas | @E 99 | R | S | ||||
| CRB_CJORSS | C | 6 | 0 | Id. Jor. SS | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DCJORS | C | 220 | 0 | Descr Jor SS | @! | V | S | ||||
| CRB_CJORSA | C | 6 | 0 | Id. Jor. Sab | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DCJOSA | C | 220 | 0 | Des Jor Sab | @! | V | S | ||||
| CRB_QTDHJF | N | 2 | 0 | Qtd Horas Fx | @E 99 | R | S | ||||
| CRB_JORSEG | C | 6 | 0 | Cod Jor Seg | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORSE | C | 220 | 0 | Des Jor Seg | @! | V | S | ||||
| CRB_JORTER | C | 6 | 0 | Cod Jor Ter | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORTE | C | 220 | 0 | Des Jor Ter | @! | V | S | ||||
| CRB_JORQUA | C | 6 | 0 | Cod Jor Qua | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORQA | C | 220 | 0 | Des Jor Qua | @! | V | S | ||||
| CRB_JORQUI | C | 6 | 0 | Cod Jor Qui | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORQI | C | 220 | 0 | Des Jor Qui | @! | V | S | ||||
| CRB_JORSEX | C | 6 | 0 | Cod Jor Sex | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORSX | C | 220 | 0 | Des Jor Sex | @! | V | S | ||||
| CRB_JORSAB | C | 6 | 0 | Cod Jor Sab | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORSA | C | 220 | 0 | Des Jor Sab | @! | V | S | ||||
| CRB_JORDOM | C | 6 | 0 | Cod Jor Dom | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DJORDO | C | 220 | 0 | Des Jor Dom | @! | V | S | ||||
| CRB_CODTUR | C | 1 | 0 | Cod Trn Flex | @! | R | S | ||||
| CRB_CODJTF | C | 6 | 0 | Cod Jor Flex | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DCODJT | C | 220 | 0 | Des Jor Flex | @! | V | S | ||||
| CRB_TPEJES | C | 2 | 0 | Tp. Escala | @! | Pertence(" |1 |2 |9 ") | R | 1=12 x 36;2=24 x 72;9=Outros | S | ||
| CRB_QTDHJE | N | 2 | 0 | Qtd Hs Flex | @E 99 | R | S | ||||
| CRB_CODJES | C | 6 | 0 | Cod Jor Esp | @! | xFunVldCmp("C90",,,,2,,.T.) | C90 | R | S | ||
| CRB_DCODJE | C | 220 | 0 | Des Jor Esp | @! | V | S | ||||
| CRB_CNPJSD | C | 14 | 0 | CNPJ Sind. | @R 99.999.999/9999-99 | xFunVldPJF(,2,.F.) | R | S | |||
| CRB_ALVJUD | C | 6 | 0 | Id Proc Jud | @! | xFunVldCmp("C93",,,,2,,.T.) | C93 | R | S | ||
| CRB_DALVJU | C | 220 | 0 | Des Proc Jud | @! | V | S | ||||
| CRB_VERANT | C | 14 | 0 | Ver Ant Reg | @! | R | S | ||||
| CRB_STATUS | C | 1 | 0 | Status Reg. | @! | Pertence(" 012349") | R | 0=Reg.Valido;1=Reg.Invalido;2=Reg.Transmitido;3=Reg.Transmitido com inconsistencia;4=Reg.Transmitido valido;9=Em Processamento | S | ||
| CRB_PROTUL | C | 44 | 0 | Ult. Prot. | @! | R | S | ||||
| CRB_PROTPN | C | 44 | 0 | Pnlt. Prot. | @! | R | S | ||||
| CRB_EVENTO | C | 1 | 0 | Id. Evento | @! | Pertence("IAE") | R | I=Inclusao;A=Alteracao;E=Exclusao | S | ||
| CRB_ATIVO | C | 1 | 0 | Reg. Ativo? | @! | Pertence("12") | R | 1=Sim;2=Nao | S | ||