FIELDNAMEPrompt Table: PSDBFIELD
FIELDVALUEEFFDTDefault: %date
A=Active
I=Inactive
Default: A
PSXLATITEM |
| PeopleSoft Field Name | Field Type | Description |
|---|---|---|
| FIELDNAME | VARCHAR2(18) NOT NULL | Field Name Prompt Table: PSDBFIELD |
| FIELDVALUE | VARCHAR2(4) NOT NULL | Field Value |
| EFFDT | DATE | Effective Date Default: %date |
| EFF_STATUS | VARCHAR2(1) NOT NULL | Effective Status A=Active I=Inactive Default: A |
| XLATLONGNAME | VARCHAR2(30) NOT NULL | Translate Long Name |
| XLATSHORTNAME | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| LASTUPDDTTM | DATE | 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. |
| LASTUPDOPRID | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| SYNCID | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 06 February 2013 |