FORM_SRC_VW (SQL View)	Index Back
Form Search Record Form Search Record

FORM_SRC_VW

(SQL View)

Form Search Record

SELECT a.created_by , a.seq_nbr , a.form_subject , a.form_type , b.EODC_DOC_KEY , a.form_priority , a.form_due_date , a.form_appr_status , a.created_dttm FROM ps_form a JOIN PS_FORM_TYPE t ON a.form_type = t.form_type AND t.FLUIDMODE = 0 LEFT OUTER JOIN ps_eodc_form_xref b ON a.FORM_TYPE = b.SD_RECNAME AND a.SEQ_NBR = b.SEQ_NBR

Related Language Record: FORM_SRC_VW_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

3 FORM_SUBJECT Character(100) VARCHAR2(100) NOT NULL Subject

4 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow
Prompt Table: FORM_TYPE

5 EODC_DOC_KEY Character(150) VARCHAR2(150) NOT NULL Document Key String

6 FORM_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low

7 FORM_DUE_DATE Date(10) DATE Due Date

8 FORM_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
0=All
A=Approved
C=Cancelled
E=Denied
H=On Hold
I=Initial
P=Pending Approval

9 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	FORM_SUBJECT	Character(100)	VARCHAR2(100) NOT NULL	Subject
4	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow Prompt Table: FORM_TYPE
5	EODC_DOC_KEY	Character(150)	VARCHAR2(150) NOT NULL	Document Key String
6	FORM_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Priority 1=1-Critical 2=2-Urgent 3=3-Standard 4=4-Low
7	FORM_DUE_DATE	Date(10)	DATE	Due Date
8	FORM_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	work order approval status 0=All A=Approved C=Cancelled E=Denied H=On Hold I=Initial P=Pending Approval
9	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time