RA_TL_DEFN_A_VW(SQL View) |
Index Back |
---|---|
Active Table Load DefinitionsThese are used for loading the active definition. |
SELECT RECNAME , DESCR , STATUS FROM PS_RA_TL_DEFN WHERE STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RA_REC_PHYS_VW |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |