SDF_COMMENT_VW

(SQL View)
 Index Back

SELECT A.SD_RECNAME ,A.LABEL18 ,A.SEQ_NUM ,B.SD_FLDTYPE ,A.SD_GRP_COL FROM PS_FS_SD_GLC_VW A ,PS_FS_SD_RECFLD B WHERE A.SD_RECNAME = B.SD_RECNAME AND A.SD_FLDNAME = B.SD_FLDNAME UNION SELECT A.SD_RECNAME ,A.LABEL18 ,A.SEQ_NUM ,B.SD_FLDTYPE ,A.SD_GRP_COL FROM PS_FS_SD_GRC_VW A ,PS_FS_SD_RECFLD B WHERE A.SD_RECNAME = B.SD_RECNAME AND A.SD_FLDNAME = B.SD_FLDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record

Prompt Table: FS_SD_REC_VW

2 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

4 SD_FLDTYPE Character(1) VARCHAR2(1) NOT NULL Use Type
C=Code
D=Date
F=Yes/No
L=Section
M=Time
N=Number
P=Prompt
S=Signed Number
T=Text
5 SD_GRP_COL Character(1) VARCHAR2(1) NOT NULL Column
L=Left Column
R=Right Column

Default Value: L