EMPLIDSCCFP_UT_BND(SQL View) |
Index Back |
|---|---|
Pop Select Unit Test Source*** For Internal Use only - DO_NOT_SHIP *** Population Selection Unit Test Source Record |
| SELECT EMPLID ,SCCPS_UT_CHAR1 ,SCCPS_UT_NUM1 ,SCCPS_UT_DEC1 ,SCCPS_UT_SNUM1 ,SCCPS_UT_DATE1 ,SCCPS_UT_TIME1 ,SCCPS_UT_DTTM1 FROM PS_SCCPS_UT_SRC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SCCPS_UT_CHAR1 | Character(15) | VARCHAR2(15) NOT NULL | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test Char 1 field |
| 3 | SCCPS_UT_NUM1 | Number(10,0) | DECIMAL(10) NOT NULL | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test field |
| 4 | SCCPS_UT_DEC1 | Number(18,5) | DECIMAL(17,5) NOT NULL | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test field |
| 5 | SCCPS_UT_SNUM1 | Signed Number(19,5) | DECIMAL(17,5) NOT NULL | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test field |
| 6 | SCCPS_UT_DATE1 | Date(10) | DATE | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test field |
| 7 | SCCPS_UT_TIME1 | Time(15) | TIMESTAMP | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test field |
| 8 | SCCPS_UT_DTTM1 | DateTime(26) | TIMESTAMP | *** For Internal Use only - DO_NOT_SHIP *** Pop Selection Unit Test field |