TSCRPT_DEFLT_TYPE0=Last TS130 Control Number
1=TS131 Processing Counter
2=TS131 Sending Counter
A=Earliest Sort Date
B=Early Sort Date
C=Latest Sort Date
D=Late Sort Date
S=Transcript As of Date
T=Report Request Last
TSCRPT_DEFAULTS(SQL Table) |
Index Back |
|---|---|
Default Transcript DatesThis table hold default information used by the transcript process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TSCRPT_DEFLT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Default type for transcript default record. The record holds different dates and counters, used for transcript processing. Numbers include transcript request number, TS130 control number and TS131 processing counter.
Dates are used in SRPCTEXT.DMS, in the view TSCRPT_DEFDT_VW.
0=Last TS130 Control Number 1=TS131 Processing Counter 2=TS131 Sending Counter A=Earliest Sort Date B=Early Sort Date C=Latest Sort Date D=Late Sort Date S=Transcript As of Date T=Report Request Last |
| 2 | TSCRPT_DEFLT_CHAR | Character(20) | VARCHAR2(20) NOT NULL | Transcript Default Character |
| 3 | TSCRPT_DEFLT_NUM | Number(9,0) | DECIMAL(9) NOT NULL | Transcript Default Number |
| 4 | TSCRPT_DEFLT_DATE | Date(10) | DATE | Transcript Default Date |