SSR_RECNAMEPrompt Table: PSRECDEFN
SSR_FIELDNAMEPrompt Table: PSRECFIELD
SSR_ADC_DTFLDVW(SQL View) |
Index Back |
|---|---|
Record Date Field ViewRecord Date Field View |
| SELECT DISTINCT A.RECNAME , A.FIELDNAME , B.FIELDTYPE , A.USEEDIT , 'N' FROM PSRECFIELD A , PSDBFIELD B WHERE A.SUBRECORD <> 'Y' AND B.FIELDNAME = A.FIELDNAME AND (B.FIELDTYPE = 4 OR B.FIELDTYPE = 6) UNION SELECT DISTINCT A.RECNAME , B.FIELDNAME , A.USEEDIT , C.FIELDTYPE , 'N' FROM PSRECFIELD A , PSRECFIELD B , PSDBFIELD C WHERE A.SUBRECORD = 'Y' AND A.FIELDNAME <> 'SCC_CAF_SBR' AND B.RECNAME = A.FIELDNAME AND C.FIELDNAME = B.FIELDNAME AND (C.FIELDTYPE = 4 OR C.FIELDTYPE = 6) UNION SELECT DISTINCT A.RECNAME , B.FIELDNAME , A.USEEDIT , C.FIELDTYPE , 'Y' FROM PSRECFIELD A , PSRECFIELD B , PSDBFIELD C WHERE A.SUBRECORD = 'Y' AND A.FIELDNAME = 'SCC_CAF_SBR' AND B.RECNAME = A.FIELDNAME AND C.FIELDNAME = B.FIELDNAME AND (C.FIELDTYPE = 4 OR C.FIELDTYPE = 6) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Extension Record
Prompt Table: PSRECDEFN |
| 2 | SSR_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: PSRECFIELD |
| 3 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 4 | USEEDIT | Number(10,0) | DECIMAL(10) NOT NULL | Field Use and Edit Flags- USEEDIT reference |
| 5 | SSR_CAF_IND | Character(1) | VARCHAR2(1) NOT NULL | Copy Common Attributes |