GPAU_STP_BIR_VW(SQL View) |
Index Back |
|---|---|
Single Touch PayrollSTP - Birth date view |
| SELECT EMPLID , BIRTHDATE , EXTRACT(DAY FROM BIRTHDATE ) , EXTRACT(MONTH FROM BIRTHDATE ) ,EXTRACT(YEAR FROM BIRTHDATE ) FROM PS_PERSON |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 3 | DAY1 | Number(2,0) | SMALLINT NOT NULL | Day 1 |
| 4 | MONTH1 | Number(2,0) | SMALLINT NOT NULL | Month 1 |
| 5 | YEAR_DISPLAY | Number(4,0) | SMALLINT NOT NULL | Year Display |