EMPLIDEMPL_RCDBEGIN_DTEND_DATE01=In Progress
02=Open
03=Close per Absence
04=Close Expired
05=Close
Default Value: 02
GPBR_TR_VACN_VW(SQL View) |
Index Back |
|---|---|
Vacation Acquisitive Period.Vacation Entitlement Period View Brazil. |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.BEGIN_DT ,A.END_DT ,A.SEQNUM ,A.END_DT ,A.AP_VAC_STATUS_BRA ,A.SERVICE_MONTHS ,A.ORIG_BEGIN_DT FROM PS_TR_CONTRAC_BRA A |
| # | 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 Record |
| 3 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 4 | END_DATE |
Date(10) | DATE | End Date |
| 5 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | GPBR_PER_END_DT | Date(10) | DATE | Period End Date -- Vacations Brazil |
| 7 | GPBR_AP_VAC_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Acquisitive Period Status
01=In Progress 02=Open 03=Close per Absence 04=Close Expired 05=Close Default Value: 02 |
| 8 | SERVICE_MONTHS | Number(4,1) | DECIMAL(3,1) NOT NULL | Months of Service |
| 9 | ORIG_BEGIN_DT | Date(10) | DATE | original begin date |