GPIT_ANFEE_NRVW(SQL View) |
Index Back |
|---|---|
ANF Data - VIEW for el rel mapYou write this record for employee who are granted ANF VIEW for the element relationship map |
| SELECT EMPLID , EMPL_RCD , EFFDT , GPIT_PIN_TABIN_NUM + 50000000 , GPIT_ANF_TABLE , GPIT_ANF_CALC , EFF_STATUS , GPIT_ANF_FAM_INC , GPIT_ANF_CSF , GPIT_ANF_NUCL_MBR , GPIT_ANF_UND_CHIL , GPIT_ANF_DIS_CHIL , GPIT_ANF_OTH_FAM , GPIT_ANF_FLAG_ODIS , GPIT_ANF_FLAG_PDIS , CURRENCY_CD FROM PS_GPIT_ANF_EE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | GPIT_PIN_TABIN_NUM | Number(8,0) | INTEGER NOT NULL |
Inps Table
Prompt Table: GPIT_PIN_ANF_VW |
| 5 | GPIT_ANF_TABLE | Character(3) | VARCHAR2(3) NOT NULL | Inps Table Number |
| 6 | GPIT_ANF_CALC | Character(1) | VARCHAR2(1) NOT NULL | ANF Calc |
| 7 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 8 | GPIT_ANF_FAM_INC | Number(13,2) | DECIMAL(12,2) NOT NULL | Family Income |
| 9 | GPIT_ANF_CSF | Character(1) | VARCHAR2(1) NOT NULL |
Family condition code
1=Y Spouse N Dis 2=N Spouse N Dis 3=Y Spouse Y Dis 4=N Spouse Y Dis |
| 10 | GPIT_ANF_NUCL_MBR | Number(2,0) | SMALLINT NOT NULL | Members Family Unit |
| 11 | GPIT_ANF_UND_CHIL | Number(2,0) | SMALLINT NOT NULL | Children Under Age |
| 12 | GPIT_ANF_DIS_CHIL | Number(2,0) | SMALLINT NOT NULL | Disable Children of Age |
| 13 | GPIT_ANF_OTH_FAM | Number(2,0) | SMALLINT NOT NULL | Other Relatives |
| 14 | GPIT_ANF_FLAG_ODIS | Character(1) | VARCHAR2(1) NOT NULL |
Flag other disabled relatives
Y/N Table Edit Default Value: N |
| 15 | GPIT_ANF_FLAG_PDIS | Character(1) | VARCHAR2(1) NOT NULL |
Flag other disabled relatives
Y/N Table Edit Default Value: N |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EUR Prompt Table: CURRENCY_CD_TBL |