DB_PLATFORM0=DB2/MVS
1=SQLBase
2=Oracle
3=SQL Server
4=DB2/UNIX
5=Rdb
6=Informix
7=DB2/400
8=Sybase SQLServer
9=Microsoft SQLServer
MC_DTTM_PARMS(SQL Table) |
Index Back |
|---|---|
Mass Change Datetime Parms |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DB_PLATFORM |
Character(1) | VARCHAR2(1) NOT NULL |
Database Platform
0=DB2/MVS 1=SQLBase 2=Oracle 3=SQL Server 4=DB2/UNIX 5=Rdb 6=Informix 7=DB2/400 8=Sybase SQLServer 9=Microsoft SQLServer |
| 2 | DATETIMEOUT_PREFIX | Character(50) | VARCHAR2(50) NOT NULL | Date Time Out Prefix |
| 3 | DATETIMEOUT_SUFFIX | Character(50) | VARCHAR2(50) NOT NULL | Date Time Out Suffix |
| 4 | DATETIMEIN_PREFIX | Character(50) | VARCHAR2(50) NOT NULL | Date Time In Prefix |
| 5 | DATETIMEIN_SUFFIX | Character(50) | VARCHAR2(50) NOT NULL | Date Time In Suffix |
| 6 | DATEOUT_PREFIX | Character(50) | VARCHAR2(50) NOT NULL | Date Out Prefix |
| 7 | DATEOUT_SUFFIX | Character(50) | VARCHAR2(50) NOT NULL | Date Out Suffix |
| 8 | DATEIN_PREFIX | Character(50) | VARCHAR2(50) NOT NULL | Date In Prefix |
| 9 | DATEIN_SUFFIX | Character(50) | VARCHAR2(50) NOT NULL | Date In Suffix |