TSCRPT_REQ_HIST (SQL Table)	Index Back
Transcript Request History

TSCRPT_REQ_HIST

(SQL Table)

Transcript Request History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

2 TRANSCRIPT_SEQ_NO Number(3,0) SMALLINT NOT NULL Transcript Seq No

3 TRANSCRIPT_DET_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number

4 TS130_ST_CONTROL Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number

5 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

7 TSCRPT_ACTION Character(1) VARCHAR2(1) NOT NULL Action for history record of new transcript request.
B=Batch Generate
E=Email
G=Generate
M=Batch E-Mail
P=Print

8 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name

9 TS131_PURPOSE Character(2) VARCHAR2(2) NOT NULL TS131 Transaction Set Purpose Code
06=Confirmation
18=Reissue

10 DATE_PROCESSED Date(10) DATE Date TS131 was processed.

11 TS131_CONTROL Number(9,0) DECIMAL(9) NOT NULL TS131 Control - save a unique counter on the hist record when generating TS130, in order to process accurately the incoming TS131.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
2	TRANSCRIPT_SEQ_NO	Number(3,0)	SMALLINT NOT NULL	Transcript Seq No
3	TRANSCRIPT_DET_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	TS130_ST_CONTROL	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Control Number
5	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	TSCRPT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action for history record of new transcript request. B=Batch Generate E=Email G=Generate M=Batch E-Mail P=Print
8	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
9	TS131_PURPOSE	Character(2)	VARCHAR2(2) NOT NULL	TS131 Transaction Set Purpose Code 06=Confirmation 18=Reissue
10	DATE_PROCESSED	Date(10)	DATE	Date TS131 was processed.
11	TS131_CONTROL	Number(9,0)	DECIMAL(9) NOT NULL	TS131 Control - save a unique counter on the hist record when generating TS130, in order to process accurately the incoming TS131.