SETIDTEMPLATE_NAMEEFFDTDefault Value: %date
AR_TEMPLATE_VW(SQL View) |
Index Back |
|---|---|
Report Template View |
| SELECT A.SETID ,A.TEMPLATE_NAME ,EFFDT ,A.DESCR150_MIXED ,A.REPORT_VERSION FROM PS_AR_RPT_TEMPLATE A WHERE A.REPORT_VERSION=( SELECT MAX(REPORT_VERSION) FROM PS_AR_RPT_VERSION) AND A.STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TEMPLATE_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Template Name |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 5 | REPORT_VERSION | Character(10) | VARCHAR2(10) NOT NULL | Report Version |