PTEXTDATASRCNAMEPTEXTSRCNAME01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
00=00
10=10
20=20
30=30
40=40
50=50
1=Monday
2=Tuesday
3=Wednesday
4=Thursday
5=Friday
6=Saturday
7=Sunday
PTEXTXS_SHD_R(SQL Table) |
Index Back |
|---|---|
External Data Integration |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTEXTDATASRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Data Source Name |
| 2 | PTEXTSRCNAME |
Character(128) | VARCHAR2(128) NOT NULL | Definition |
| 3 | PTEXTXSCHEDULE | Character(1) | VARCHAR2(1) NOT NULL | Schedule |
| 4 | PTEXTXS_DATE | Date(10) | DATE | Date |
| 5 | PTEXTXS_UNITS | Character(1) | VARCHAR2(1) NOT NULL | Units |
| 6 | PTEXTXS_TIME | Time(15) | TIMESTAMP | Time |
| 7 | PTEXTXS_HH | Character(2) | VARCHAR2(2) NOT NULL |
Hour
01=01 02=02 03=03 04=04 05=05 06=06 07=07 08=08 09=09 10=10 11=11 12=12 |
| 8 | PTEXTXS_MM | Character(2) | VARCHAR2(2) NOT NULL |
Minute
00=00 10=10 20=20 30=30 40=40 50=50 |
| 9 | PTEXTXS_HHVAL | Number(3,0) | SMALLINT NOT NULL | Every |
| 10 | PTEXTXS_MMVAL | Number(2,0) | SMALLINT NOT NULL | Value |
| 11 | PTEXTXS_WEEKDAYS | Character(1) | VARCHAR2(1) NOT NULL |
Days
1=Monday 2=Tuesday 3=Wednesday 4=Thursday 5=Friday 6=Saturday 7=Sunday |