FS_SD_FORM_L_VW(SQL View) |
Index Back |
---|---|
Supplemental Data FieldSupplemental data field. Used in Form Wizard. Bridge View. |
SELECT SD_RECNAME , SD_FLDNAME , DESCR100 , LABEL18 , SD_FLD_STATUS , SD_FLDTYPE , SD_FLDLEN , FIELDNAME , PROMPT_RECNAME , BUS_UNIT_FIELD , SETID , FORM_LONG_LABEL , SD_FLD_REQUIRED , EOSD_INSTR , EOSD_UPPER_CASE FROM PS_FS_SD_RECFLD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SD_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Supplementa Data Record |
2 | SD_FLDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
4 | LABEL18 | Character(18) | VARCHAR2(18) NOT NULL | Label |
5 | SD_FLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Supplemental data field status
A=Activated D=In Design Default Value: D |
6 | 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 |
7 | SD_FLDLEN | Character(4) | VARCHAR2(4) NOT NULL |
Field Length
1=1 10=10 15=15 15.4=15.4 20=20 254=254 30=30 4=4 5=5 50=50 7.2=7.2 9=9 |
8 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: FS_SD_NONKEYFLD |
9 | PROMPT_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Prompt record name in Chart field template
Prompt record name in Form and Approval Builder
Prompt Table: FS_SD_PROMPT_VW |
10 | BUS_UNIT_FIELD | Character(18) | VARCHAR2(18) NOT NULL | Business Unit Field |
11 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SETID_TBL |
12 | FORM_LONG_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Long Label |
13 | SD_FLD_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Field Required |
14 | EOSD_INSTR | Long Character | CLOB | Instructions |
15 | EOSD_UPPER_CASE | Character(1) | VARCHAR2(1) NOT NULL |
Uppercase
N=N Y=Y Default Value: N |