EMPLIDPrompt Table: PER_ORG_ASGN
EMPL_RCDPrompt Table: PER_ORG_ASGN
PERORGASGBRA_CV(SQL View) |
Index Back |
|---|---|
PER_ORG_ASG_BRA MSG ClairviaClone of PER_ORG_ASG_BRA record for Clairvia Fullsync message |
| SELECT BRA.EMPLID , BRA.EMPL_RCD , BRA.INS_DAYS_BRA , BRA.INS_MONTHS_BRA , BRA.INS_YEARS_BRA FROM PS_PER_ORG_ASG_BRA BRA , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = BRA.EMPLID AND ASG.EMPL_RCD = BRA.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PER_ORG_ASGN |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: PER_ORG_ASGN |
| 3 | INS_DAYS_BRA | Character(2) | VARCHAR2(2) NOT NULL | INSS Days Brazil |
| 4 | INS_MONTHS_BRA | Character(2) | VARCHAR2(2) NOT NULL | INSS Months Brazil |
| 5 | INS_YEARS_BRA | Character(2) | VARCHAR2(2) NOT NULL | INSS Years Brazil |