# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
2 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
3 |
PURGE_AFTER_X_DAYS |
Number(2,0) |
SMALLINT NOT NULL |
Purge All Older Than (in Days)
|
4 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
5 |
SEPARATE_BIL_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used by Governement Contracts to separate Billing and Revenue transactions
|
6 |
ANALYSIS_TYPES |
Character(50) |
VARCHAR2(50) NOT NULL |
Analysis Types
|