PTSF_SBO_NAMEPTSF_SRC_RECNAMEPTSF_SRC_FIELDNAMECON=Constant Date
CUR=Current Effective Dt
INS=Instance Creation Dt
PSPTSF_GN_DSPRC(SQL Table) |
Index Back |
|---|---|
Activity Guide reportingActivity Guide reporting - Data Source Processing |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_SBO_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Search Definition (see PSPTSF_SD). |
| 2 | PTSF_SRC_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name |
| 3 | PTSF_SRC_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 4 | PTSF_PRC_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Processing Type
CON=Constant Date CUR=Current Effective Dt INS=Instance Creation Dt |
| 5 | PTSF_CONST_DATE | Date(10) | DATE | Constant Date |