HR_RFW_RECDEFN(SQL Table) |
Index Back |
|---|---|
Record DefinitionRecord Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
|
| 2 | Character(2) | VARCHAR2(2) NOT NULL |
Record Type
TB=Table VW=View Default Value: TB |
|
| 3 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |