GPBR_NRP_SEF_VW(SQL View) |
Index Back |
|---|---|
SEFIP RelationshipSEFIP Relationship |
| SELECT PIN_TAKE_NUM+50000000 , ABSENCE_REASON , EFFDT , STATUS , GPBR_DAYS_BEFORE , GPBR_RETURN_CODE , GPBR_ABSENCE_CODE , GPBR_RETURN_CODE2 , GPBR_ABSENCE_CODE2 , GPBR_MULTPLE_OCCUR , GPBR_RETURN_CODE3 , GPBR_ABSENCE_CODE3 FROM PS_GPBR_SEFIP_ABSP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 2 | ABSENCE_REASON |
Character(3) | VARCHAR2(3) NOT NULL |
absence reason
10=Vacations |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 5 | GPBR_DAYS_BEFORE | Number(3,0) | SMALLINT NOT NULL | This field is used to indicate how many days before the current date to show the history date range. |
| 6 | GPBR_RETURN_CODE | Character(2) | VARCHAR2(2) NOT NULL | Return Code |
| 7 | GPBR_ABSENCE_CODE | Character(2) | VARCHAR2(2) NOT NULL |
Absence Code
10=Sickness 20=Work Accident 30=Vacations Prompt Table: GPBR_SEF_ABS_VW |
| 8 | GPBR_RETURN_CODE2 | Character(2) | VARCHAR2(2) NOT NULL | Return Code |
| 9 | GPBR_ABSENCE_CODE2 | Character(2) | VARCHAR2(2) NOT NULL |
Absence Code
Prompt Table:
GPBR_SEF_ABS_VW
|
| 10 | GPBR_MULTPLE_OCCUR | Character(1) | VARCHAR2(1) NOT NULL |
If It is Multiple Occurs
Y/N Table Edit Default Value: N |
| 11 | GPBR_RETURN_CODE3 | Character(2) | VARCHAR2(2) NOT NULL | Return Code |
| 12 | GPBR_ABSENCE_CODE3 | Character(2) | VARCHAR2(2) NOT NULL |
Absence Code
Prompt Table:
GPBR_SEF_ABS_VW
|