SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
TEMPLATE_NAMEREPORT_VERSIONPrompt Table: AR_TMPLT_VSN_VW
EFFDTA=Active
I=Inactive
Default Value: A
A=As of Date
D=Due Date
Default Value: D
AR_RPT_TEMPLATE(SQL Table) |
Index Back |
|---|---|
Report Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | TEMPLATE_NAME |
Character(10) | VARCHAR2(10) NOT NULL | Template Name |
| 3 | REPORT_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Report Version
Prompt Table: AR_TMPLT_VSN_VW |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 6 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
| 7 | AGING_BASIS_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Basis Date for Aging
A=As of Date D=Due Date Default Value: D |